MajP
You've got your good things, and you've got mine.
- Local time
- Yesterday, 22:14
- Joined
- May 21, 2018
- Messages
- 8,529
In my DB i have a query viewer which basically is a form with a subform. You can pick any query from the list and it loads read only in the subform. The source objects are queries and not forms in datasheet view. I Like to be able to sort and filter the queries and then export the sorted filtered data. The only way I know to do this is to build a querydef based of the filtered sql and export that query def. This would be easy if these were forms in datasheet view. Is there a way to reference the dynamic datasheet and get the filter and sql? Or is there another way to export the filtered data? The intent was not to have to make a lot of forms based on the queries and just use the queries. Thanks.