Stop VBA execution until form is closed

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Bakema (anonymous_at_discussions.microsoft.com)
Date: 04/19/04 

Date: Mon, 19 Apr 2004 09:38:26 -0700

Hi,

May this is simple, but I have failed so far.

I want to open a form programatically, and then stop
execution of the procedure for checking data in the form.
After closing the form (and loading some of the checked
data in public strings for use elsewhere) the procedure
should resume automatically and access the public strings
(for putting them in a Word document).
Opening the form is no problem, loading the form's data
to strings on closing works fine, but I did not manage to
making the procedure wait so that somebody can check and,
if necessary, edit the form's data.

Is this possible and if yes, how. If No is there a way
around this problem?

Bakema

Relevant Pages

  • Re: Stop VBA execution until form is closed
    ... >execution of the procedure for checking data in the form. ... >After closing the form (and loading some of the checked ... >should resume automatically and access the public strings ... >to strings on closing works fine, but I did not manage to ...
    (microsoft.public.access.formscoding)
  • Stop VBA execution until form is closed
    ... >After closing the form (and loading some of the checked ... >should resume automatically and access the public strings ... >(for putting them in a Word document). ... >to strings on closing works fine, but I did not manage to ...
    (microsoft.public.access.formscoding)