Pass Filter To Query With VBA (1 Viewer)

[robertbwainwright]

I have a subform (this subform's source object can change to one of three diffrent forms) that allows the users to filter. I have a requirement to output the filtered data to excel. I am creating a query based on the subforms record source called qryExport. I now want to pass the subforms filter to qryExport. I have the string setup now I just need to know how to pass the data into the filter property of the query.

Thanks,
Robert

 

[jdraw]

Can you show the code you have?

I have the string setup now......

 

[robertbwainwright]

Can you show the code you have?

jdraw, Thanks for your reply. I might not be explaining myself well. If I open a query it has a filter property. I would like to be able to use (set) that filter property from VBA.

 

[pr2-eugin]

You can use the QueryDefs object to edit an existing Query.