Can Access run simultenously vba code ?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 2 forms which are possible to be opened at the same time. Inside a
procedure of both forms, it loops and wait for a condition to be true before
run next statement. What happened is when first form is opened and before it
loop, Second form is both opened and looping. Then I back to first form and
try to make it loop but it doesn't work. Debug show me that vba code in first
form is freezed while vba code in second form is running (eventhough loop
contain DoEvents).

Does it mean that VBA code in Access run step by step and can not run
simultenously ?
 
Well, i think i managed once to run code in a loop and same time code fired
by event, but this was not a good solution either. if you really need such
kind of loops - better try to use forms' timer event

HTH
 
Back
Top