subforms fields populating from a list of values

  • Follow



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

0
Reply Danny 6/13/2007 2:15:22 AM

0 Replies
288 Views

(page loaded in 0.234 seconds)


Reply: