Filter Report From Combo Box

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
 
J

Jeff Boyce

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/
 
Top