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?
David_W_RAsked:
Who is Participating?
 
peter57rCommented:
You can open a form using the acDialog parameter and that will halt the code until the form is closed.
0
 
Kamaraj SubramanianApplication Support AnalystCommented:
I think you can use the Sleep method
0
 
David_W_RAuthor Commented:
Just what the doctor ordered!  Thanks very much.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.