How to link main form to subform

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!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top