Filter a form on a field in a subform two levels deep

[olaf]

Hi everybody!

I'm trying to make it possible for the users of my databasesystem to
freely do whatever filtering they like on a main-form, a sub form and a
sub form in the sub form. To make this work on two levels, works fine.
I change the recordssource quite similar to this article:
http://allenbrowne.com/ser-28.html

The problem arises when I have a sub form in the sub form, and want the
user to be able to filter in all levels. Are there anyone who have any
experience in this area?

Thanks for any help!
-olaf

[Allen Browne]

Presumably you are trying to filter the main form based on a value in a
grand-child table, e.g.:
Table1 (one) => Table2 (many)
Table2 (one) => Table3 (many)

If so, you should be able to include all 3 tables in the RecordSource
statement, and so you can set the WHERE clause based on a field from Table3.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"olaf" <ol***@runit.no> wrote in message
news:11*********************@g47g2000cwa.googlegro ups.com...

Hi everybody!

I'm trying to make it possible for the users of my databasesystem to
freely do whatever filtering they like on a main-form, a sub form and a
sub form in the sub form. To make this work on two levels, works fine.
I change the recordssource quite similar to this article:
http://allenbrowne.com/ser-28.html

The problem arises when I have a sub form in the sub form, and want the
user to be able to filter in all levels. Are there anyone who have any
experience in this area?

Thanks for any help!
-olaf