"Refreshing" or saving form

  • Thread starter Thread starter RitchieJHicks
  • Start date Start date
R

RitchieJHicks

Hi,

I have number of modules which rely on the data added to the form. However,
if my uses amends a record and then runs the module, the data is not updated
to the amended information and they have to exit the record and come back
into it for the changes to take affect.

How can I set the form to save the new data before running the module so
that the amended data is used?
 
Where would one enter the code please? In the module being opened? Or the
main form code?
 
Could you maybe place a button on the form and in the On CLick event type:
Me.Requery? Once clicked, it should update the information in your tables.
 
Place that line in the code that calls your other function/sub, before you
make that call.
 
Back
Top