subform for Invoice

[cd saya via AccessMonster.com]

Hi,
I have 2 tables Invoice and InvoiceDetails. They have a relationship 1 to
many. In Invoice table the items are:
(invoiceno,companyname,invoicedate,paymentdue,subamount and totalamount)
and in InvoiceDetails table the items are:
(invoiceno,description,quantity,unitprice and amount). In my invoice form
they have form(invoice table) and subform(invoicedetails table).

My problem is once I key-in the invoice number in the main form and would
like to have the invoice number auto add to the subform of invoicedetails
with more than one row or many rows.

Thanks in advance.

 

[Penguin]

Check the link Child and Master for the subform. Set them to the
control name of the invoice text box.

 

[cd saya via AccessMonster.com]

Hi Penguin,
The link child and master subform are already set it to invoiceno.
Which invoice text box does you refer. And what want is the invoiceno of
subform add to the invoicedetails table.

Thanks.