taicho
Registered Abuser
- Local time
- Yesterday, 18:23
- Joined
- Dec 13, 2005
- Messages
- 24
I am in desperate need of your my help my fellow "Accesorians"! I have 3 Forms in this order within eachother-
Purchase Orders
Purchase Orders SubF(Subform in Purchase Orders)
SummaryBackOrders(Subform in Purchase Orders SubF
Now the purpose of SummaryBackOrders was to seperate UnitsOrdered and UnitsReceived of a Product off of Purchase OrdersSubF so I could sum only the UnitsRec'd and UnitsOrd'd for one part number instead of summing all the UnitsOrdered for all the parts on said purchase order. The "SummaryBackOrders" form runs off a duplicate of the query that "Purchase ORders SubF" runs off of except that the query for
"SummaryBackOrders" has 2 expressions "SumOrd" and "SumRec" and these work perfect because since the subform links thru the child & master fields I set it only ends up summing the UnitsOrdered and UnitsReceived for each part which is what I wanted...now here is the problem when I created a control in "SummaryBackOrders" subform to take Sum of SumOrd and Sum of SumRec and link it into a control on "Purchase Orders SubF" it gets an #Error in it's place UNLESS I expand the Subform which is "SummaryBackOrders" and which case #Error becomes replaced by the appropiate calculation, my question therefore is how do I use that data in "SummaryBackOrder" without having to expand it?
Purchase Orders
Purchase Orders SubF(Subform in Purchase Orders)
SummaryBackOrders(Subform in Purchase Orders SubF
Now the purpose of SummaryBackOrders was to seperate UnitsOrdered and UnitsReceived of a Product off of Purchase OrdersSubF so I could sum only the UnitsRec'd and UnitsOrd'd for one part number instead of summing all the UnitsOrdered for all the parts on said purchase order. The "SummaryBackOrders" form runs off a duplicate of the query that "Purchase ORders SubF" runs off of except that the query for
"SummaryBackOrders" has 2 expressions "SumOrd" and "SumRec" and these work perfect because since the subform links thru the child & master fields I set it only ends up summing the UnitsOrdered and UnitsReceived for each part which is what I wanted...now here is the problem when I created a control in "SummaryBackOrders" subform to take Sum of SumOrd and Sum of SumRec and link it into a control on "Purchase Orders SubF" it gets an #Error in it's place UNLESS I expand the Subform which is "SummaryBackOrders" and which case #Error becomes replaced by the appropiate calculation, my question therefore is how do I use that data in "SummaryBackOrder" without having to expand it?
