Hello all,
I have just posted over in the welcome sub, and this is my first proper post so here goes..(i'm sure the answer is very simple)
I am currently trying to create an invoice form using a subform for the invoice line items. I want to be able to total the subform in the main form, and have found a couple of solutions in the web.
I have managed to carry this out, and can calculate the subtotal on the main for using an unbound textbox. The solution involves a hidden calculated text box in the sub-form footer.
The issue I have is that I cant figure out how to now update the relevant table fields with the result.
When I use a combobox I have the 'control source' and the 'row source' properties to pull data from and write data to. With a text box I dont have the 'Row source' to configure??
I would like to have the sub-total, GST (VAT) and Grand-Total stored in the table rather than calculating it everytime on the fly.
Is this the right approach??
Many thanks in advance.
I have just posted over in the welcome sub, and this is my first proper post so here goes..(i'm sure the answer is very simple)
I am currently trying to create an invoice form using a subform for the invoice line items. I want to be able to total the subform in the main form, and have found a couple of solutions in the web.
I have managed to carry this out, and can calculate the subtotal on the main for using an unbound textbox. The solution involves a hidden calculated text box in the sub-form footer.
The issue I have is that I cant figure out how to now update the relevant table fields with the result.
When I use a combobox I have the 'control source' and the 'row source' properties to pull data from and write data to. With a text box I dont have the 'Row source' to configure??
I would like to have the sub-total, GST (VAT) and Grand-Total stored in the table rather than calculating it everytime on the fly.
Is this the right approach??
Many thanks in advance.