Subform filter Access 2007

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!
 
K

KARL DEWEY

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.
 
P

PJ

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...
 

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

Unbound control on continuous form goes blank 1
synchronize sub forms-part 2 0
Performance slow down after apply a filter(change from 0 records to many records) 6
Form and subform weirdness when linking to SQL Server 2005 via OD 2
Changing case on multiple records in subform 14
Apply Filter to Subform 7
Filtering subform based on another subform 1
How to the determine the current subform using a macro 1

Top