requery

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You first need to save the data, then requery the form:

Me.Dirty = False
Me.Requery
 
sandrao said:
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
 
Thanks very much. both yours and the other method both work fine, I also
found another method that also works:


DoCmd.RunCommand acCmdRefreshPage
 
Back
Top