Prompts

[kim]

Can you prompt with a drop down box?

If I want to prompt the user in a query for example:

Please enter fruit:

the user can enter apples, oranges, pineapple/melon, etc.

now if the user types pineapple it will not show up, so is
there a way to use a drop down?

 

[fredg]

Can you prompt with a drop down box?

If I want to prompt the user in a query for example:

Please enter fruit:

the user can enter apples, oranges, pineapple/melon, etc.

now if the user types pineapple it will not show up, so is
there a way to use a drop down?

Yes... if you place the comto box on a form.
Then change the query criteria from [Please enter fruit] to:
forms!FormName!ControlName

It is important to make sure the datatype of the combo's bound column
is the same as the datatype of the field used for criteria, i.e. Text
to Text, or Number to Number.