Need code to wait until form refreshes

[spliterman]

I have a text box on a continuous form which is a calculation based on a field. I have an SQL statement that updates a record in a table with the data in this calculation field. In order to get the correct calculation, the form needs refreshed so I have the me.refresh before the SQL update statement. The problem is that the SQL Update statement begins before the form completely refreshes so I need a way for the code to wait until the form refreshes to continue.

 

[PHV]

You may consider the DoEvents function.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886