How to create a modal Dialogue Box?

[WDSnews]

In Access, I wonder how to create a modal dialogue box that returns a value
to the calling form. I need my code to invoke a dialogue box in which the
user selects a name from a dropdown list, then exits the dialogue returning
the People.ID to the code which called it. I know how to do this in
ObjectPal. And in Access, I can build a small form with a combobox and two
buttons. I can write code to Open the second form on the screen. However,
what's the magic to...

....make the small form modal, like a dialogue box?
....suspend the first form's code until the modal box exits?
....return a People.ID to the calling form?
....and resume executing the first form's code?

 

[fredg]

In Access, I wonder how to create a modal dialogue box that returns a value
to the calling form. I need my code to invoke a dialogue box in which the
user selects a name from a dropdown list, then exits the dialogue returning
the People.ID to the code which called it. I know how to do this in
ObjectPal. And in Access, I can build a small form with a combobox and two
buttons. I can write code to Open the second form on the screen. However,
what's the magic to...

...make the small form modal, like a dialogue box?
...suspend the first form's code until the modal box exits?
...return a People.ID to the calling form?
...and resume executing the first form's code?

Open the dialog form in dialog.
Code will be suspended until the dialog form is made not visible using
a command button on that form, after which processing will continue.

' Open the form in dialog
DoCmd.OpenForm "DialogFormName", , , , , acDialog
' Read the control on that form after its command button is clicked
Me.PeopleID = forms!DialogFormName!ControlOnForm
' Close the dialog form
DoCmd.Close acForm, "DialogFormName"

 

[Jeanette Cunningham]

Hi WDSnews.
Open the dialog form in acDialog mode - this stops all code from executing
on the calling form.
DoCmd.OpenForm NameOfForm, WindowMode:=acDialog

The code behind the close or save button on the dialog form should not close
the form, but just make it invisible.
Once the dialog form is hidden, the code back on the calling form continues.
The next line of the calling form is to read the value it wants from the
hidden dialog form.
Then the calling form closes the hidden dialog form.
DoCmd.Close acForm, NameOfForm


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[Albert D. Kallal]

In Access, I wonder how to create a modal dialogue box that returns a
value to the calling form. I need my code to invoke a dialogue box in
which the user selects a name from a dropdown list, then exits the
dialogue returning the People.ID to the code which called it. I know how
to do this in ObjectPal. And in Access, I can build a small form with a
combobox and two buttons. I can write code to Open the second form on the
screen. However, what's the magic to...

...make the small form modal, like a dialogue box?
...suspend the first form's code until the modal box exits?
...return a People.ID to the calling form?
...and resume executing the first form's code?

I explain step by step with code examples here:

http://www.members.shaw.ca/AlbertKallal/Dialog/Index.html

 

[WDSnews]

very helpful. thank you.

Open the dialog form in dialog.
Code will be suspended until the dialog form is made not visible using
a command button on that form, after which processing will continue.

' Open the form in dialog
DoCmd.OpenForm "DialogFormName", , , , , acDialog
' Read the control on that form after its command button is clicked
Me.PeopleID = forms!DialogFormName!ControlOnForm
' Close the dialog form
DoCmd.Close acForm, "DialogFormName"

 

[WDSnews]

I appreciate your help. Thank you.

Hi WDSnews.
Open the dialog form in acDialog mode - this stops all code from executing
on the calling form.
DoCmd.OpenForm NameOfForm, WindowMode:=acDialog

The code behind the close or save button on the dialog form should not
close the form, but just make it invisible.
Once the dialog form is hidden, the code back on the calling form
continues.
The next line of the calling form is to read the value it wants from the
hidden dialog form.
Then the calling form closes the hidden dialog form.
DoCmd.Close acForm, NameOfForm


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[WDSnews]

Nice description. thank you.

I explain step by step with code examples here:

http://www.members.shaw.ca/AlbertKallal/Dialog/Index.html