S
spacerocket
I am doing a PO database and in the PO form, I created a subform Order_Info
to enter the order items. Both forms are linked via OrderNo in the
relationship table. In the subform, I put created a txtbox Sum_Total which
sums all order (LineTotal). I created another txtbox Total in the PO form
which shows the value of Sum_Total, but I get the error #Name. In the Total
txtbox, my Control Source is:
=[Order_Info Subform].Form!Sum_Total
I've checked the sample Order db from Access db. I put the Link Child Fields
and Link Master Fields as OrderNo. Pls. help!!
to enter the order items. Both forms are linked via OrderNo in the
relationship table. In the subform, I put created a txtbox Sum_Total which
sums all order (LineTotal). I created another txtbox Total in the PO form
which shows the value of Sum_Total, but I get the error #Name. In the Total
txtbox, my Control Source is:
=[Order_Info Subform].Form!Sum_Total
I've checked the sample Order db from Access db. I put the Link Child Fields
and Link Master Fields as OrderNo. Pls. help!!