Combobox report.

jakobt

Active Member
Joined
May 31, 2010
Messages
298
I have a report linked to a table. I want to filter the report on the Customer ID. Is that possible. Is it possible to insert a combobox in a report, in the header maybe.
 

Some videos you may like

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

Trevor G

Well-known Member
Joined
Jul 17, 2008
Messages
6,610
Office Version
2016
Platform
Windows
You can't add combobox in reports.
 

jakobt

Active Member
Joined
May 31, 2010
Messages
298
Would I then need to link the report to a query. And filter in the query on the customer I want to be filtered on for the report?
 

Trevor G

Well-known Member
Joined
Jul 17, 2008
Messages
6,610
Office Version
2016
Platform
Windows
I would use the query to link to the report. You could also use a form as an interface, you can resize the form to fit around a combobox and it can refresh once you select from the combobox that way it gives you the impression of a combobox in a report. So the report uses the query, but the query use an expression to the form control and refresh the report with a macro after update or on change events from the combobox.
 

welshgasman

Well-known Member
Joined
May 25, 2013
Messages
821
I would open the report with the criteria of the Customer ID in the WHERE argument?

I would not tie the query to any form controls unless that was the only place that query was ever used.?

HTH
 

Watch MrExcel Video

Forum statistics

Threads
1,102,350
Messages
5,486,345
Members
407,541
Latest member
Emilybuhman

This Week's Hot Topics

Top