I want to create a report from a filter made through autofilter in a form in base. Is there a way to do that?
As far as I know, the auto-filter form control just ‘auto-generates’ an SQL QUERY ‘behind the scenes’ so to speak. But I think the only way to use it in a report is to re-create that query either in Design View or SQL View or use the query Wizard. Once you’ve got your query working (from the query list), you can use it in your report. You can also write an SQL query in the report source data properties directly (choose CONTENT TYPE SQL command and enter your query in CONTENT below).