I am using access 2010.
I am using a form to view / edit a table. At runtime, when the user clicks on a button, I would like to create a popup / form with a bound combobox. The user would select a value in the combobox and then that value would be returned to the main form.
The name of the combobox would be cmboName
This combobox would be bound to [Table Merchants].[Names]
Value would be returned to the main form in the variable UserResponse
This is a formidable challenge for me. I would appreciate any help that I can get.