S
sschermer
I am working with a database which has a form which
contains two subforms. The Parent form diplays data from
a tblFolder, and it is on this form that a calculated
control with a total must appear.
Te first subform contains data from tblXover, which
captures information about companies submitting payments,
which is related to the tblFolder in a 1-to-many
relationship. Expanding the data grid line for a company
record brings up a second subform (child14) which displays
or allows data entry of details of payments stored in
tblDetail. TblDetail is related to tblXover in a many-to-
one relationship.
The problem is that the payment information
(tblDetail.Amount sent) needs to be totalled to appear in
caculated field on the main form (frmFolder.txtTotal).
The total needs to be running. I kow I haven't got the
control reference syntax correct in this email. I need
help.
contains two subforms. The Parent form diplays data from
a tblFolder, and it is on this form that a calculated
control with a total must appear.
Te first subform contains data from tblXover, which
captures information about companies submitting payments,
which is related to the tblFolder in a 1-to-many
relationship. Expanding the data grid line for a company
record brings up a second subform (child14) which displays
or allows data entry of details of payments stored in
tblDetail. TblDetail is related to tblXover in a many-to-
one relationship.
The problem is that the payment information
(tblDetail.Amount sent) needs to be totalled to appear in
caculated field on the main form (frmFolder.txtTotal).
The total needs to be running. I kow I haven't got the
control reference syntax correct in this email. I need
help.