Hi everybody
I have a Form called FrmInvoice and a subform called FrmInvoice_Details_subform. The subform has the details of the products. The fields are linked to my Products table(Prduct_Code,Product and Price) and the Quantity field to my invoice table. The Product_Code is selected via lookup from Products table and is working fine, but since the info are from 2 seperate tables I had to make a textbox on the form to calculate the subtotal for each record. This also works fine. My problem is that I need t put the value in the Subtotal textbox in the Invoice_Details table in the subtotal field. Is there a way to copy the value from the form into the table?