Delayed Update?

  • Thread starter Thread starter Chaplain Doug
  • Start date Start date
C

Chaplain Doug

Access 2002. I have one (continuous) subform in which
persons names and a check field called [SELECTED] are
displayed. Next to this subform is another subform which
is just supposed to display the names of those people
checked (SELECTED) in the other subform. On the "After
Update" event on the check box I do a requery on the other
subform. It does not display the name of the person just
checked (SELECTED) but lags behind by one person. Why
so? How fix? Thanks.
 
Chaplain said:
Access 2002. I have one (continuous) subform in which
persons names and a check field called [SELECTED] are
displayed. Next to this subform is another subform which
is just supposed to display the names of those people
checked (SELECTED) in the other subform. On the "After
Update" event on the check box I do a requery on the other
subform. It does not display the name of the person just
checked (SELECTED) but lags behind by one person. Why
so? How fix? Thanks.
Click to expand...


I think you might have forgotten to save the record before
doing the Requery.

An easy way to force saving a record you know has been
edited is:

Me.Dirty = False
 
Other than
Me.Dirty = False
How may I programmatically save a record?
By the way, Me.Dirty = False worked. Thanks.


-----Original Message-----
Chaplain said:
Access 2002. I have one (continuous) subform in which
persons names and a check field called [SELECTED] are
displayed. Next to this subform is another subform which
is just supposed to display the names of those people
checked (SELECTED) in the other subform. On the "After
Update" event on the check box I do a requery on the other
subform. It does not display the name of the person just
checked (SELECTED) but lags behind by one person. Why
so? How fix? Thanks.
Click to expand...


I think you might have forgotten to save the record before
doing the Requery.

An easy way to force saving a record you know has been
edited is:

Me.Dirty = False
Click to expand...
 
Other than
Me.Dirty = False
How may I programmatically save a record?
Click to expand...

DoCmd.RunCommand acCmdSaveRecord

Neither one is particularly clear from the help file!
 
Back
Top