MS Access open selection Form and use Value in prior Form

[frobo]

hello together

how it's possible to open a form (popup, bound, so it sticks until the user closes it), let the user choose a value and then OK and have the chosen value used in the prior form?

tia
frobo

 

[PHV]

Open the form as modal (acDialog)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[frobo]

Well where is this constant used?

And my other question is:
How I can let the user choose from a dropdown on the modal form and use the value in my vba code on another form?

tia
frobo

 

[frobo]

i got it to work by having a hidden field in the mainform, but now, when i use the modal form to let the user choose a value, the code still goes on, not waiting for the user input.
but I need the value in the ongoing code.
any idea?

tia

 

[RoyVidar]

As stated by PHV, use the acDialog option when opening the form.

[tt]docmd.openform "myform",,,,,acdialog[/tt]

Roy-Vidar

 

[frobo]

thanks alot! problem solved
especially thanks for the fast replies!

love u guys ;P