• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 243
  • Last Modified:

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?
0
David_W_R
Asked:
David_W_R
1 Solution
 
Kamaraj SubramanianApplication Support AnalystCommented:
I think you can use the Sleep method
0
 
peter57rCommented:
You can open a form using the acDialog parameter and that will halt the code until the form is closed.
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.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now