By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,851 Members | 1,193 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,851 IT Pros & Developers. It's quick & easy.

How to retrieve a filter values from subdatasheet in vba

P: 1
I need to know how to retrieve all filters applied to a subdatasheet in a form, using a vba routine, in order to use it in a dynamic reports.
Dec 6 '16 #1
Share this Question
Share on Google+
1 Reply

Expert 100+
P: 1,107
Here are a couple links that might provide some insight:
Referring to Items on a Sub-Form
Refer to Form and Subform properties and controls
If your case, you might want to check out Neopa's first example and do something like this:
Expand|Select|Wrap|Line Numbers
  1. sSubFormFilterVariable = Me.[SubformName].Form.Filter
Dec 7 '16 #2

Post your reply

Sign in to post your reply or Sign up for a free account.