Reporting from a query

  • Thread starter Thread starter Bobber
  • Start date Start date
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
 
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]
 
Back
Top