Update?

[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

 

[Ken Snell]

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.

 

[Ken Snell]

You're welcome.

Thanks Ken, works great.