Update queries advice needed - URGENT

[ljubo lecic via AccessMonster.com]

I am trying to initate a sequence of update queries
that are called on the "On_Click" event in the form.
The sequence is:
DoCmd.OpenQuery"update_query_1"
DoCmd.OpenQuery"update_query_2"
DoCmd.OpenQuery"update_query_3"
"Update_query_1" is actually preparing data needed for
"update_query_2".In the beginning everything worked fine
but then I noticed some odd things happening.I may be
wrong but it seems to me that that these queries are called almost
simultaniously( I thought that logic was
that "update_query_2" would be called after "update_query_1" had been
finished)
Could someone expirienced in access ( I am not ) give
me an advice how to call these queries in sequence.
(i.e. I want "update_query_2" not to start before
"update_query_1 is finished)

 

[Van T. Dinh]

Try using the Execute Method of the Database Object (DAO Library needed).
Use DoEvents and the Idle Method between the Execute statements.

Check Access VB Help on special terms I mentioned above.