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

  • Follow


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
0
Reply Utf 4/6/2007 9:10:04 AM

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

-- 
Good Luck
BS"D


"Nelson The Missing Lead" wrote:

> 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
0
Reply Utf 4/6/2007 9:16:01 AM


1 Replies
443 Views

(page loaded in 0.05 seconds)


Reply: