How to interrupt code to make data changes
Posted on 2010-08-19
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?