Originally Posted by
June7
I had a similar issue. My solution is VBA code to construct an SQL and uses QueryDefs collection to modify an Access query object then export that query. I do that method because the criteria is more complex.
Does your form have Access query object as RecordSource or is the RecordSource an sql statement? Is your filtering done by parameters in query that refer to comboboxes for input? I expect that a query object with parameters should work in your case. Do you want to export to a new or existing worksheet? Are you using TransferSpreadsheet method?