Export Filtered Form

[DH]

I have a form that I use "Filter By Selection" to filter the form.

For example, I will filter to form to only included states from "FL"

I have put a command button with the onclick event set to "outputto" and the query set to "query1".

The form datasource is the "query1" I would therefore like to export this query with the filter applied.

So I filter the data and click the command button. However, all records are exported, not just the records from the state of "FL".

Am I missing something here or is there another way to do this???

Thanks!