[Webinar] Streamline your web hosting managementRegister Today

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

[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

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