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

filter by form ADP problems

P: 9
I have a form with 2 subforms on it.

The 2 subforms have a table-valued function as their recordsource and the input parameters property that 'reads' the parameter values (field values) from the main form.

It all works fine when I open the form...records in my subforms are ok.

If I apply the Filter By Form Access functionality on the main form and filter by a field that is used as a parameter for my subforms, the main form gets filtered correctly but the subforms remain as they were after the opening of the form. As if the subforms don't get the info that I filtered the main form. As if there's no automatism...the problem is that I don't know how to make this work.

Any ideas?
Jan 9 '08 #1
Share this Question
Share on Google+
3 Replies


Expert 100+
P: 374
then you need to requery the subforms in order to update them with the current filter applied to the main form.

me.ControlName.requery
Jan 15 '08 #2

P: 9
I wish it was that easy...I'm trying to go with requery in applyfilter event but no change.
Jan 21 '08 #3

Jim Doherty
Expert 100+
P: 897
I wish it was that easy...I'm trying to go with requery in applyfilter event but no change.
Have a look at your 'serverfilter' property for the form Sara and alter that to suit your requirements for the dataset supplied to the subform. Its difficult to supply an example for you, given I don;t strictly know the layout of what you have there... but 'serverfilter' is the direction you need to go

Jim :)
Jan 21 '08 #4

Post your reply

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