[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 240
  • 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

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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