Reports/query by user from drop down menu

[osullipa]

I have a report which lists spend by customer. It is based on a query which requests the customer number I want the report for.

How can I get the query/report to offer a drop down list of the customer numbers available, so that I don't have to manually enter the number each time from memory!

Thanks in advance!

Regards

Peter

 

[Rich]

Use a combo box on a popup form to pass the parameters to the query

 

[osullipa]

Reports / query by user from drop down menu

Use a combo box on a popup form to pass the parameters to the query

Thanks for this. Can you explain further or point me in the direction of an example on how to pass the parameter? I'm relatively new to access and although I can build the forms ok, I haven't mastered this yet.
Many thanks.

Peter