Link to a table by ID

Hi,

I want to add to another table where the CustID = ID in a label on a form. What I have so far is below. Using Access and DAO

Any help appreciated.

Regards,

Alan.

Invoice.AddNew
Invoice("CustID") = lblID
Invoice("InvoiceNo") = lblInvoiceNo
Invoice("Part1") = cboPart1.Text ‘and so on
Invoice.Update ‘so far so good

Customer.Addnew

This is where I want to put a labels contents, lblTotal.Caption into the customer table. Customers.Fields("Total") Where frmInvoice.lblID.caption = Customers.Fields("CustID")