Re: Stop VBA execution until form is closed
From: Marshall Barton (marshbarton_at_wowway.com)
Date: 04/19/04
- Next message: Darrell: "Events on a tab page"
- Previous message: Chris Nebinger: "Forms "returning" a value"
- In reply to: Bakema: "Stop VBA execution until form is closed"
- Next in thread: es: "Stop VBA execution until form is closed"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 19 Apr 2004 12:05:39 -0500
Bakema wrote:
>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.
Open the form in Dialog mode:
DoCmd.OpenForm "nameofform", . . ., WindowMode:= acDialog
-- Marsh MVP [MS Access]
- Next message: Darrell: "Events on a tab page"
- Previous message: Chris Nebinger: "Forms "returning" a value"
- In reply to: Bakema: "Stop VBA execution until form is closed"
- Next in thread: es: "Stop VBA execution until form is closed"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
