subforms fields populating from a list of values

[Danny]

I have 3 forms 1 main form a 2nd subform1 related to that and a 3rd
subform 1 related to subform 1.

there are 3 tables.
table 1 (main form built on) has a primary field called field 1 that
relates to table 2 (subform 1 built on) called field 2. Table 2 has a
primary field called field 1 that relates to table 3 field 2.

I would like to know is it possible for a user if they select from a
list of values in field one(table 1) of form 1 to show all data
associated with that in the other 2 subforms? like a query would only
in a form format

Also is it possible to select from a list of values in subform 1(table
2) that will populate the main form 1 and the subform 2?

I use access 2003
Thanks