requery

[sandrao]

Is there any way to requery information in a form without specifing every
field that new information was entered? I know that as soon as I go into a
new record the information will be updated and appear in the Report. Can you
get around having to move to a new record they back again to have the Report
desplay all the new information entered in the various fields?

sandrao

 

[Douglas J. Steele]

You first need to save the data, then requery the form:

Me.Dirty = False
Me.Requery

 

[Marshall Barton]

Is there any way to requery information in a form without specifing every
field that new information was entered? I know that as soon as I go into a
new record the information will be updated and appear in the Report. Can you
get around having to move to a new record they back again to have the Report
desplay all the new information entered in the various fields?

In the form button's Click event, add a line of code to save
any changes right before the code that opens the report

If Me.Dirty THen Me.Dirty = False

 

[sandrao]

Thanks very much. both yours and the other method both work fine, I also
found another method that also works:


DoCmd.RunCommand acCmdRefreshPage