How to fill a subform automatically.

[Guest]

I have a form InvoicngForm. When I enter a PO No. , It automatically gets the
details of the P.O. - I have a subform - which is my invoice detail. What I do
is copy what records I want in the PONo SubForm and the paste in on my Invoice
details subform.
basically I am doing a copy and paste. How can I create a button so that
when I click it, it will copy all the records in the po subform into the
invoice detail subform.
Then I can just delete any record I dont want in the invoice subform.

Will appreciate any help. TIA

albert silver

 

[Alex White MCDBA MCSE]

Duplication of data is a bad idea, think about using the same table for PO
details and Invoice details with a field for PO_No and Invoice_No, setting
the Invoice_No when you are doing your invoicing also get the benefit of
being able put more than 1 PO detail on to a single invoice.