Get a value from another form

[Guest]

I would like to call a form from another and have it return a value. So I
can link to that record. A lookup form. Common enough, I thought.
I've looked everywhere and can't find out how in Access.
Does it have to have popup property and/or modal set to true?

If a form cant return a value, I've tried setting a public variable. But
either way, the code right after the openform command executes immediately
instead of waiting for the called form to close. (Calling a modal form in
FoxPro achieves this.)

 

[Albert D. Kallal]

You can read about how to do this here:

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