How do I open form and wait from VB Script

[foobar]

While executing a VB script in Access 2003 I would like to "pop up a dialog
to get some user input" and then proceed with the script.

As far as I can figure out, VB Access does not support dialogs as such but
rather I build a Form that contains the various UI elements that I would
like to use to get the user's input.

How do I display the form and wait for the user to click Ok/Cancel on the
form?

The DoCmd.OpenForm returns immediately.

Do I have to build a "sleep" function that periodically wakes up to see if
the form has set a global variable "I Have been closed?".

What I'm trying to do is a build a glorified MsgBox to get more than just
Yes/No/Cancel from the user.

Daniel

 

[Albert D. Kallal]

If you just need the code to wait, then use input box



strAnswer = inputbox("please enter your name")

if strAnswer <> "" then
msgbox "Your name is " & strAnswer
end if


The above code does wait. If you want/need to ask MORE then one thing, then
you can use a form you build as a dialog form.

I explain how here:
http://www.members.shaw.ca/AlbertKallal/Dialog/Index.html

 

[foobar]

Thanks. EXTREMELY helpful and right on point.

Daniel

 

[ruralguy via AccessMonster.com]

Just so the record is straight, a WindowMode of acDialog will stop code
execution in the calling form until the form is closed or made invisible.
This is all covered in the VBA help on OpenForm.