Filter a Report with from a Form

  • Thread starter Thread starter Gary Hull
  • Start date Start date
G

Gary Hull

I would like to be able to use a combo box on a form to filter a report

Thanks
Gary
 
Set the criteria in your query (report's record source) to something like:

[Forms]![frmYourFormName]![cboYourComboName]

The form must be open prior to opening your report.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pass Subform filter to subform in report 0
Refreshing a subform 2
Problem with Combo Boxes using Filter By Form and sending to Repor 2
Need combo box to refresh when moving to new record 2017 1
Open and filter report 1
Search Filter for Report 9
Should I re-create criteria using form filter of just use the relevant query as recordsource? 2
Problem copying Filter made from ComboBox 5

Back
Top