parameter value.

[Guest]

Conerning the report paramenter box, I would like to insert a drop down menu
to choose a value rather than type one in. Example: Instead of entering a
customer number have a drop down menu to select a customer from. How can this
be acconplished?

 

[Rick B]

This is asked and answered all the time. Did you try searching for your
answer before posting a new thread? You have to create your field in an
unbound form and allow the user to make the selection, then use that entry
in the source of your query. Do a search and you will find several xamples.

Rick B

 

[AlCamp]

Randy,
Probably you'll want to create a Pop-Up form that allows the user to
select a customer ID (example... frmPopUp with combo box cboCustID).
Use the AfterUpdate event of that combo box to open the report. (leave
the PopUp form open)
In the query behind your report, in the criteria for the CustomerID
field...
=Forms!frmPopUp!cboCustID
will filter your report results accordingly.
hth
Al Camp