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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Delete code competing with BeforeUpdate validation 2
A MsgBox or Form to display info without waiting for a close comma 2
Command button plus message 2
Code help with IsNot( ) operator 3
SCAN.CO - £5,300 Gone. No PC. No Answers. One of the Worst Companies Ive Ever Dealt With. 3
IF THEN ELSE CODING missing a step 2
How do I know a query is finished? 12
Access Problem with Update Command in Access 3

Back
Top