Subform filter Access 2007

  • Thread starter Thread starter PJ
  • Start date Start date
P

PJ

I have two subforms [FSub1] and [FSub2] in [FormMain]. Both subforms are
Continuous Forms depending on different queries.

In [FSub2] I want to apply a filter like:
[FieldX]=[Forms]![FMain]![FSub1]![FieldY].
However, although FSub1 contains several records, the result is a single
record being shown in FSub2.

How can I solve this problem, please? Thanks in advance for any help offered!
 
Do not use [Forms]![FMain]![FSub1]![FieldY] but the query field for [FieldY].
Use that field as criteria for [FSub1] query.
But remember that you will need to refresh each time [FieldY] is changed.
 
Thanks a lot, Karl!

"KARL DEWEY" skrev:
Do not use [Forms]![FMain]![FSub1]![FieldY] but the query field for [FieldY].
Use that field as criteria for [FSub1] query.
But remember that you will need to refresh each time [FieldY] is changed.

--
Build a little, test a little.


PJ said:
I have two subforms [FSub1] and [FSub2] in [FormMain]. Both subforms are
Continuous Forms depending on different queries.

In [FSub2] I want to apply a filter like:
[FieldX]=[Forms]![FMain]![FSub1]![FieldY].
However, although FSub1 contains several records, the result is a single
record being shown in FSub2.

How can I solve this problem, please? Thanks in advance for any help offered!
Click to expand...
Click to expand...
 
Back
Top