G
Guest
I have two forms. They can both be open at the same time. Form1 is the
driver form and has a "next" button. When pressed, it calls Routine1 which
reads the next set of data, populates the fields on Form1, then calls
Routine2 to populate the fields on Form2.
This works great until they start pressing the Next button really fast.
Routine2 doesn't finish processing each call and eventually an error is
generated, and the wrong data can be on Form2.
Is there any way to ensure that when calling Routine2, it is completed
before it is called again? Doesn't seem like this is a DoEvents issue, but
any help would be greatly appreciated.
driver form and has a "next" button. When pressed, it calls Routine1 which
reads the next set of data, populates the fields on Form1, then calls
Routine2 to populate the fields on Form2.
This works great until they start pressing the Next button really fast.
Routine2 doesn't finish processing each call and eventually an error is
generated, and the wrong data can be on Form2.
Is there any way to ensure that when calling Routine2, it is completed
before it is called again? Doesn't seem like this is a DoEvents issue, but
any help would be greatly appreciated.