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
|
|