Combo box for dialog box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a parameter query and I would like the dialog box that comes to be a
combo box to show me the possible choices to enter into the field for a
search. Is their a property setting to do that or do I have to set up a
macro?

Any suggestions,

Thanks
 
Create a form with a combo, and a button
The user can select a value from the combo, and then run the query that has
a link to the combo in the form

Select * From TableName Where FieldName = Forms!FormName!ComboName
 
No. The Parameter dialog is only rudimentary.

For a serious interface, you need to use a form.
Create a form with the combo.
Open the form, and select the data.
Your query than then refer to it like this:
[Forms].[Form1].[Combo5]
 
Back
Top