Calling another Dialog box from an Event Proc

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a dialog box that has a number of list boxes that allow the user enter
data. One of the list boxes allows multiple selections. After pressing the
OK button, the Event for the button runs code that processes the data. If an
check button on the form is checked, I want to open another form to gather
additional information.
As In
Do While some condition
If CheckBox then
DoCmd.OpenForm("AnotherForm")
...
Endif
Loop

However, while the form opens, it does not get the focus, and the code
following the OpenForm command continues to run.
How do I stop and process the second form?
Thanks for your help
Ken
 
Try

DoCmd.OpenForm "AnotherForm", , , , , acDialog

or

DoCmd.OpenForm FormName:="AnotherForm", WindowMode = acDialog
 
Thank you, that is what I needed.

Douglas J Steele said:
Try

DoCmd.OpenForm "AnotherForm", , , , , acDialog

or

DoCmd.OpenForm FormName:="AnotherForm", WindowMode = acDialog
Click to expand...
 
Back
Top