Re: Last record does not get updated immediately. Why?

[alicejwz]

Re: Last record does not get updated immediately. Why?

Good Morning,

I was wondering if someone can me understand this-
I have a form(subform)gets its recordsource base on a table through a query in the openform event. The subform displays a record and there are bunch of check boxes w/i this record. This first record after checking/unchecking a box the table updates the change immediately, but the last record when editing the check box the value does not get updated in the table until I move to previous record(clicking on previous btn). Why won't the last record get updated immediately like the other record(s)?

Thanks for an explanation.

 

[maxmangion]

did you try to requery you form ?

 

[alicejwz]

Re: last record not updated. Why?

Thanks for your replied.

Yes, the requery did updated the table but it also refreshed the form which I don't want.
This is what I'm trying to accomplish. In click events of the cmdnext and cmdFinish btns it calls a query and check if a check box is checked. If it is true it moves to the next record, if not it pops up a message and form displays the same record. Somehow by executing requery method it updates the table but it also moves to next record.
Why won't the value of the check box gets updated soon after you clicked on it on the last record? It updated previous record immediately?