Hi all, I have an order form (orderFRM) which displays info such as who the order belongs to, the invoice number, payment method etc. This form inturn includes a subform (orderProductsFRM) which displays information about the products that are included within the order. This subform is displayed as a datasheet so all the products beloning to an order can be seen at the same time. One of the fields in this subform is Total Price, which displays the total price (i.e. quantity * unit price) of a product.
What i am struggling to be able to do is add all of the product totals together in an order and then display this new total in the 'Order total' text field in the fom. Any help with this would be much appreciated, cheers.
What i am struggling to be able to do is add all of the product totals together in an order and then display this new total in the 'Order total' text field in the fom. Any help with this would be much appreciated, cheers.
