Filter Form from header click

[bikeordie1]

Hello,

I have a product list that's organized into categories as a report. is there a way for the user to click on the category header and have the report filter to that category only? instead of creating a multi-select box and filtering from there, i'd like it if they could just click on the header within the report and have it filter from there.



Thanks

[June7]

Reports are not really intended to be interactive but something like what you want is possible in ReportView, not PrintPreview. Can right click on a field to activate shortcut menu and input filter criteria.

[bikeordie1]

Yea thats fairly easy. Thanks

[June7]

Might also be able to use VBA behind the section Click event to set report Filter property and requery the report. Never tried this.