Delayed Update?

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.
 
M

Marshall Barton

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
 
C

Chaplain Doug

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...
 
J

John Vinson

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Basing a subform on a selection from either of two subforms 3
Style Gallery View 3
subform based on external SQL won't requery 1
Avoid nulls in Combo box 2
Close popup form from a continuous subform 6
Refresh data in sub forms when one sub form is edited 8
How to find the name of the present subform 7
Locked Subform still lets me delete a record 2

Top