filter two subforms at once

R

rob c

I am working on a form which has two subforms, sub1 and sub2. The two
subforms have a one-to-one relatinoship based on a field called "projects".

There are several fields which can be filtered on the sub1, but are not on
sub2, they are "product", "salesrep", "region". There can be multiple
projects on the sub1 when one of these fields is filter used.

My endusers need to be able to perform a "filter by selection" on sub1 and
have the sub2 be automatically filtered so that all the records which have a
"project" number that is on sub1 after the "filter by selection" are the only
project numbers that remain on the sub2.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple Subform Calculation 1
Linking two subforms together. 3
Subform of a subform? 1
Unexpectedly prompted for parameters using parameters of form 0
Sub requery + other question 1
how to use modules so that values calculated in one of them can beused by another? 1
Two subroutines controlling one form 4
Problem refreshing child form 1

Top