Requery subform does not recognize last changed record

[jdttek]

I have a standard subform that has a checkbox for each record. A date field on the subform is changed (SQL Update)only for records with checkboxes selected when I run the SQL UPDATE Code. HOWEVER, the last checkbox is not recognized whenever I run the code, even when I have the code save and requery the subform and underlying table.

1. Works fine when subform is opened as standalone form, (ie, not as subform)
2. Works fine if I save the subform manually first, and then run the update.

3. Does NOT work if I save and requrey subform with code. Last checkbox is still not recognized. I have even tried closing and reopening the subform with code to forcec a record save. Still does not recognize last checkbox. Any ideas why this is happening?

JDTTEK

 

[Junior1544]

I've had this problem befor...

The way i solved this for my client is that when you goto do what ever you want to after making your changes... use code to select the first record in the subform... (I would make two moves to be safe)...

--James
junior1544@jmjpc.net
Life is change. To deny change is to deny life.