aussiecyclone
May 1st, 2001, 12:04 AM
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")
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")