Fields on Tables

[Roy]

I open a form in edit....

I have created an update query to update the table the
form is based on using criteria from the query....

Is there a way to show the updated field's data that
change as data is entered on the form without first
closing the form?

 

[Gary Miller]

After you run the query use...

Me.Requery

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________

 

[Arvin Meyer]

You need to requery the form. When you do that however, you will wind up at
the beginning of the recordset that the form is based upon. To get around
that you first capture the ID of the record to a variable, then requery,
then move back to that record. Something like:

Dim lngID as Long
'before requery
lngID = YourPrimaryKeyField

Do Requery Here

Me.RecordSetClone.FindFirst "YourPrimaryKeyField = " & lngID
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access