Combo to link table

[kike2679]

Hi.. i have a combo1(InvoiceNo) that look up the values in a table, (there are invoices numbers on it) In the Invoices table i have InvoiceNo (that is the key) and other fields like InvoiceCity, SaleDate, etc

I need to store the current date in Invoices.SaleDate = now() in Invoices table that matches with the combo1.

The Form has as RecordSource, Customers Table

Any tip or hint???

 

[RV]

Not sure what's you after.

Normally, you would raise Orders coming with Order Lines.
Your Invoices would be based on Orders that have been shipped.
Hence your Invoice Number would be issued when your Invoice is generated.
You' d use some VBA to automatically generate a new sequential Invoice Number.

RV