parameter promt question

[Guest]

I know how to enter a parameter prompt each time someone enters a query to
prompt them to type in something. i.e. put [Please Enter Name] in the
criteria portion. However, is there a way to prompt them with a list of
choices? i.e. all the Names and they can click on the one they wish to see
information on.

 

[Guest]

Rose,

The only way to accomplish this is to create a form that allows them to pick
them to pick the name, then modify the query so that rather than using the
parameter, it uses a reference to the forms control.

If you had a form (frm_PickNames) with a combo box and a command button.
You would use the combo to select the name, and the command button to run the
query or open a report or something along those lines. The query, in this
case might look like:

SELECT * from yourTable
WHERE [UserID] = Form!frm_PickNames.cbo_PickName

HTH
Dale

 

[Guest]

No.
IMHO, it is never appropriate to subject your users to parameter prompts.
Consider using controls on forms where you have much greater flexibility.