David_W_R
asked on
How to interrupt code to make data changes
I would like to know the best way to interrupt a Do Loop to display a form and make data changes.
For instance, my vba code is checking thru all contacts looking for discrepancies. when one is located, I need to make changes in one or two fields, then take up the search again where I left off.
Can I suspend the code, maybe open a form with the fields needed, make corrections, then resume the code?
If not, are there other ways to accomplish the same thing?
For instance, my vba code is checking thru all contacts looking for discrepancies. when one is located, I need to make changes in one or two fields, then take up the search again where I left off.
Can I suspend the code, maybe open a form with the fields needed, make corrections, then resume the code?
If not, are there other ways to accomplish the same thing?
I think you can use the Sleep method
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Just what the doctor ordered! Thanks very much.