make a form have similar behavior then the input function

[GandaSalada via AccessMonster.com]

I use to input parameters in a running procedure using the input function.
To be able to input mora data using lists, combo boxes and other stuff, I
would like to use a custom form instead of the input function.
Is there a way to make a form have similar behavior then the input function?

1 pause the procedure
2 open the form
3 retrieve data from the form
4 close the form
5 run procedure

Thank you
Armand

 

[Chris]

Opening a form in dialog mode should accomplish what you are looking for.

DoCmd.OpenForm YourForm,acNormal,,,,acDialog

HTH,
Chris

 

[Allen Browne]

Open the form modally:
DoCmd.OpenForm "Form2", WindowMode:=acDialog
MsgBox "Okay: you have now closed the modal for, so we continue."

 

[Albert D. Kallal]

I explain in detail how to have a form pause, and then have the calling code
examine the values from that form...

http://www.mvps.org/access/api/api0001.htm

in addition my approach means that you don't have to use global variables to
store the values, but in fact can actually return the values from a form.

 

[GandaSalada via AccessMonster.com]

Thank you all.

I explain in detail how to have a form pause, and then have the calling code
examine the values from that form...

http://www.mvps.org/access/api/api0001.htm

in addition my approach means that you don't have to use global variables to
store the values, but in fact can actually return the values from a form.