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

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

P: n/a
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

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.