Combo box on a report

B

BarryC

how would I use a combo box as criteria on a report? For example, I have a
[between] command for a date range, but I want to add a combo box for the
user to be able to select a customer name without having to type the name.
I'm not having any success creation a combo box on the report or in the sql
query for the report.
 
R

Rick B

Well, you can't create it in the query or the report. You would have to
create it in a separate unbound form and pop that up when you want the
report run. There are several examples of this.

Go to the Northwinds database and select "Print Sales Report" from the main
menu. That will show you an excellent example.

Rick B
 
Top