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

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
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sorting of Stock Name in Combo Box 1
Use Parameters in queries and reports 1
Query error, too few parameters 0
Using combo box(s) to create a query 1
Combo Box in a Query 3
Query with results in a value list from a combo box? 1
How to use txtboxes and Combo boxes in a form 3
combo box query parameters 1

Top