Passing Data form One subform to Other Subform.

[popins]

Hello,I had database for Quotation and invoice processing.
Main form Name as Quotation( which contains quoteNo, Quote date, and supplier name) and subform name as QuotationLineSubform ( which contains line items with S.No, description, Qty and Unit Price)And another Main form Name as Invoice ( which contains InvoiceNo, Invoice date, supplier name and Order Ref and subform name as InvoiceLineSubform ( which contains line items with S.No, description, Qty and Unit Price)My processI will create quotation and enter all the required details. Once my quotation is approve I want to create invoice for the same so from the QuotationLineSubform I would like to pass all the data’s to InvoiceLineSubform.Please help on this

[ranman256]

1 run an append query. This uses criteria in source table/form to add to the target table,with criteria from the target form
USE THE BUILDER TO PICK THE ITEMS ON THE FORMS. It always gets the path names correct.

or
2. Use full path names (builder) to directly add the datum.... It will look something like:
forms!form2!SubformName!form!textBox2=forms!form1! QuotationLineSubform!form!textBox1

[popins]

thanks Mr.Ranman,
really i am new to access, can you please explain in details.