I have the following sub routine which consist of many other sub routines. It work as follows:
Each sub routine has its own sql query to pull the relevant information from various tables and queries.
One or two of the routine requires populating a textbox and then using that textbox to update a table in order to get around the ms access non-compliant update query problem.
The problem i'm having is that the sql query hadn't finish running or updating and the VBA code just continues to run therefore no value is populated in the text box for it to be updated into the tables.
I've tried to use DoEvents as suggested on another post but doesn't seem to make much difference.
Can you please help suggest a technique i can use to make sure the query finish updating before VBA code continues.
Private Sub UpdateSubfrm_Click()