Reporting from a query

B

Bobber

I have a report that I am generating from a parameter query. I can ge
it to give me the default dialog box, type in a parameter and get th
report to generate exactly as I want. However, I would like to choos
the parameter from a drop down combo box of values rather than type
value in. How do I do this
 
S

Steve Schapel

Bobber,

Put your unbound combobox on a form which will be open at the time you
want to print your report. Refer to this combobox in the criteria of
the query that your report is based on, in place of the parameter
prompt, using syntax such as...
[Forms]![NameOfForm]![NameOfCombobox]
 
Top