Filter Report From Combo Box

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

Gary Hull

Hi everyone

I need to be able to filter a report from a combo box on a form

Any help will be welcomed

Thanks
Gay
 
Gary

One approach would be to modify the query on which your report is based...
you DO use a query to feed the report, right?!<g>

Open the query in design mode, go to the Criteria "cell" under the field you
wish to filter on (and which is bound to your form's combo box). Use the
wizard to "point" to the form's combo box ... when you are done it will look
something like:
Forms!YourFormName!YourComboBoxName

A couple cautions: 1) if the form isn't open, the query can't find the
combobox value; and 2) if you have used the much-discouraged lookup data
type for this field in its table, you will confuse yourself mightily -
lookup-type fields show one value, but actually store a different one.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/
 
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
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
Filtering Combo Box based off another 1
can i link/ nest combo boxes 4
Filter combo box based on another unrelated combo box 1
Filtering and Removing Filter based on a combo box 4
Using a Combo Box for Filtering a Continous Form 1

Back
Top