How to create a input box combo?

[DaniBoy]

Hello,
I have a problem!!!!. I have a query for a report where I have some parameters, between[date1] and [date2], and I have another where the user needs to put in a [name]. I want to make the imput box that pops up, to have a drop down where the user selects the pre define names. How do I do that?

Thanks

DaniBoy

 

[Shep]

An InputBox cannot contain a ComboBox.

You will need to create a new form with a ComboBox on it, configure it as a popup form and replace your InputBox code with code that opens this form instead.

Shep

 

[Nero]

Create a new unbound form.
Put an unbound combo box in the form and set the ROW SOURCE to link to the table that holds all the option for you original combo box.
Put an unbound Textbox in the new form and set the CONTROL SOURCE property to equal the new combo box and set the VISIBLE property to NO.( This is needed or the query will pick up all the values in the combo box instead of just one).
Create two control buttons ( OK and Cancel).
The OK button will use a macro to run the query.
On your query set the criteria in the field you are using to control the query to
[Forms]![new form name]![Textbox name]
(Textbox name being the one you have just created).
Now use the new form to run your query.