Subform Total to Main Form Textbox

I figured something out. Turns out the link from mahenkj2 was helpful. I changed the record source of the subform to a SQL statement that included 'o_unit_price*o_qty as product_sub' in the select statement. I then put sum(product_sub) as the control source of the fldItemSum control. It works fine now. I think I will try to redo all of my forms using detailed SQL statements or queries. Learning as I go along...
 

Users who are viewing this thread

Back
Top Bottom