bmhuettinger
Registered User.
- Local time
- Yesterday, 17:52
- Joined
- Jul 28, 2017
- Messages
- 59
Good afternoon/evening!
I have formatted form based on a query, that allows users to double-click some of the form headers, and access the Quick Filter menus, tailoring (and sorting) the form for their specific needs. I also have a report based on this form - same information in a printer-friendly format. I would like the report to take it's cue from the form, and only display the records that the user selected. I tried to do this in the underlying query, using the form fields as criteria, however in doing so, while it did display the correct results on the report, the criteria "disabled" the quick-filter menu on the form itself, leaving only the standard "text" and "number" filter menus. (My users are very limited in their familiarity/experience/confidence/capabilities of Access (or Excel, for that matter) so I need to make this as user-friendly as possible.)
I'm not super familiar with the reporting feature of Access, and I did try to add click-events on the report itself to no avail, but this is proving to be far more complicated that I think it should be...
Any guidance would be greatly appreciated!
I have formatted form based on a query, that allows users to double-click some of the form headers, and access the Quick Filter menus, tailoring (and sorting) the form for their specific needs. I also have a report based on this form - same information in a printer-friendly format. I would like the report to take it's cue from the form, and only display the records that the user selected. I tried to do this in the underlying query, using the form fields as criteria, however in doing so, while it did display the correct results on the report, the criteria "disabled" the quick-filter menu on the form itself, leaving only the standard "text" and "number" filter menus. (My users are very limited in their familiarity/experience/confidence/capabilities of Access (or Excel, for that matter) so I need to make this as user-friendly as possible.)
I'm not super familiar with the reporting feature of Access, and I did try to add click-events on the report itself to no avail, but this is proving to be far more complicated that I think it should be...
Any guidance would be greatly appreciated!