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?