How to synhronize sequence of commands?

  • Thread starter Thread starter ljubo lecic via AccessMonster.com
  • Start date Start date
L

ljubo lecic via AccessMonster.com

I have a command button with an "On Click" event procedure doing something
like this:
"DoCmd.RunSql" Update table_A where ... "
MsgBox" Update completed" "
I noticed that my update is not done at all if I imediatelly response to an
OK dialog of MsgBox and
it is completed if I wait a little bit. It seems to me
that MsgBox is not waiting previous command to complete
what is in my situation of crucial importance .
Is there a way to ensure that MsgBox is not called until
previous update is completed because exiting event procedure before
completing preceding update results
in undone update.
 
Please post the entire section of code that is causing the problem. That way
you may get an answer that works for you.

Cheers
 
Back
Top