popup form to fill in data field

[cowboy]

I have a form1 that has a field that has many options and instead of creating a combo box with a ton of options I want to open a popup form that I will set some filtering and searching options and when the user selects the item they want it will return the value to form1 in the specific field.

I think I can do this with an on click event with a text box and then when the user selects the option they want I can have the vba code insert the data into the textbox I am trying to fill in.



Does anyone have any other ideas or ways that they have done this?
Thanks.

[June7]

Global variable declared in a general module. Beware, global variables lose value if code execution is interrupted. Access (queries, forms, reports) cannot refer to VBA global variables.

TempVars - do not lose value if code execution is interrupted. Access can refer to TempVars.

[cowboy]

Yeah I thought TempVars would be a good way to do it, wasnt sure if I could do it with calling a function and returning a value.

[June7]

A function could reference global variable and Access can refer to function. Same issue if code is interrupted.

TempVars can be called directly, don't have to be in a function.