Update?

  • Thread starter Thread starter Doug
  • Start date Start date
D

Doug

I am using Access 97 , I am using a form to enter information , I have a
command button that runs a query which fills in another form. The
information from the first form has not been updated before the query runs.
How do I update the record before I run the query?
Thanks
Doug
 
Sounds as if you need to tell the first form to save its data. Put this code
step as the first step in the code for the button:

Me.Dirty = False

This will force the form to save the data.
 
Thanks Ken, works great.

Ken Snell said:
Sounds as if you need to tell the first form to save its data. Put this code
step as the first step in the code for the button:

Me.Dirty = False

This will force the form to save the data.
Click to expand...
 
Back
Top