how can i create a parameters entry in query with list/combo box?

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

Guest

I am trying to create a query with parameter entry c/w list/combo box for the
user to chose? But i can't. Pls help.

Eg. [Enter the Stock Name] { I hope that a list/combo box will come together
with the prompt so that the user don't need to know what the stock name}

Thank
 
You can't use that prompt with a combo.

What you can do is create a form with a combo box/list box where the user
can select a value, and in the query create a reference to this combo

Select * From TableName Where FieldName = Forms![FormName]![ComboName]

You can create a button in the form to open the query
 
Back
Top