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.

 

[Doug]

Thanks Ken, works great.

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.