me.filter EXPORT

[slyvsspy]

I have a form uses a bunch of different filters that are saved into the (Me.Filter). I need to transfer certain fields to a comma delimited file based on the (Me.Filter) criteria. Does anyone know how I can do this. You can't do it using the (Transfer Text) Macro because you have to define a query.

So I guess my question is how do I export using VBA? And how do I export based on (Me.Filter).

Thanks, Josh

 

[slyvsspy]

code

DoCmd.TransferText acExportDelim, ,republicanQUERY,st.txt,Yes, , ,

This is the code I am trying to run and I can't even get this to work, does anyone have any ideas?