Report based on "Filter by form" filtered recordset
Greetings,
I have a access form that has approximately 35 form elements. The filter by form element, and the Advanced Filter, allows me to reduce the recordset from the full table to a reduced recordset.
I have a report that has the same query as that form. What I would like to do is untie the query from the report, and tie the report's recordset come from the form. If the form's filter function is applied, then I want that recordset to be what goes to the report, not the whole recordset.
Can this be done?
Thanks
I have a access form that has approximately 35 form elements. The filter by form element, and the Advanced Filter, allows me to reduce the recordset from the full table to a reduced recordset.
I have a report that has the same query as that form. What I would like to do is untie the query from the report, and tie the report's recordset come from the form. If the form's filter function is applied, then I want that recordset to be what goes to the report, not the whole recordset.
Can this be done?
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Well, that's beautiful. Elegant simplicity!
ASKER
now, What I need to do is put the Me.Filter value into a field (which I've done), and then transform it to something human readable. I'll make that another question for more points.
Thanks Much.