HDI: from module, open form, pass value back into module?

[C Hayes]

baffled on this one, can anyone help?

in code

I'm in the module I open a form acdialog mode.

a simple form with a list box and an 'ok' button.

I can get the open args to fill the list box with my values from my module.

I want the form to pass the list box selected value back to the module on
the 'ok' click event and then close.

 

[C Hayes]

I think I figured it out.

modular level public variable in my module

clear the value before opening the form in dialog mode

set the value from the click event of the command button on the form and a
docmd.close

pass the modular value to a local variable.

 

[Albert D. Kallal]

I explain in detail how to have a dialog form returns values, and no global
vars are needed:

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

 

[C Hayes]

Albert ,

That is a better solution! Thanks.

Chris