trying to get a total on a main form from subform info

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 3 forms: FORM1, FORM2 is a subform in FORM1 and FORM3 is a subform in
FORM2. I have a field named QTY in FORM3 that I would like Summed on FORM1.
In the relationships; TABLE1, TABLE2 and TABLE3 have a field called BOLN.
There is one BOLN in TABLE1 for many BOLN in TABLE3. In the properties of the
forms, Link Child Fields and Link Master Fields all contain BOLN. Hopefully
this isn't too confusing. Thanks in advance.
 
I do it the simple way by creating a totals query and using it joined to my
TABLE1 in the query for the main form.
The totals query has the primary key field and count. It is joined on the
primary key field in the query for the main form.
 
Back
Top