Combobox report.

[jakobt]

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.

 

[Trevor G]

You can't add combobox in reports.

 

[jakobt]

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]

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]

I would open the report with the criteria of the Customer ID in the WHERE argument?

DoCmd.OpenReport method (Access)

Office VBA reference topic

docs.microsoft.com

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

HTH