Filter data of a form based on 1-to-M-to-M ( 3 tables)

[Guest]

With Me.filteron you can filter data of the first table ( company )but ...
how do I filter data based on the third table ;
For instance :
Table 1 = comapny
Table 2 = Subject
Table 3 = Notes

In fact I would like to filter the companies having a query on the table
Notes.

Could somebody help me?
Thanks in advance

 

[edward]

Create a Query based on joining the three tables, and then base your
form on the query rather than on the tables.

Edward

 

[Guest]

Thank you Edward
In fact I would like to maintain the records in the same form based on an
input of a independed textbox +search button.


My actual form is build as follows:

For the first table tblCompany i made a Combo wich shows me the related
records od "tblsubects" and finally the related records of tblnotes"

My goal is :
Searching all notes in tblNotes which replys to my textbox (input) and only
showing the records of tblsubject and tblCompany where there is a note found
having inpit of my textbox.

Hope you could help and thanks a lot in advance
Umberto