ComboBoxes on Form to filter a Report (Access 97)

Topic

New Reply

I have two combo boxes on a form which will be used as criteria for a report. How do I store the value selected by the user in the combo box, and then use in a query to filter my report?

Thank you,
Kim

Reply | Quote

Replies

Set source of combobox to

[query]![queryname]![fieldname]

Search MSKB for filter by form

Reply | Quote

Unless you want to store the details for printing out later, it is not so much a case of storing the value as having the query checking the values when it is run.
In the criteria field of the Query grid use the builder to get the value from the combo box on the form, some thing like
[Forms]![frmReportFilter]![cboLineName]

HTH

Peter

Reply | Quote