Need help to autopopulate a form

[Noreene]

I have been out of Access for 6 years and I can't remember anything!

 

[bob fitz]

Welcome to the forum Noreene. There are many knowledgeable people here, but AFAIK none of them claim to be psychic. What, exactly, do you need help with.

 

[Noreene]

I hit post reply too quick..sorry I have just posted it in completed form!!

 

[Noreene]

I am going to try this again. I have a form (frmInvoices) that I use to enter and print invoices. It's control source is tblInvoices. On the form I have a combobox used to choose CustomerID from tblCustomers. I also have 2 fields from another table tblNewInvoiceNumbers named ID and DateCreated that need to be populated in tblInvoices and tblNewInvoiceNumbers. Whenever I choose a CustomerID, I need it to go to tblNewInvoiceNUmbers, enter the CustomerID and then return the new invoice number to form. Also, need to enter DateCreated in tblNewInvoiceNUmbers, too. The new invoice number is an autonumber that will not appear until customerid is entered. I know this is simple, but apparently I have been away too long!! Thanks, Noreene

 

[Noreene]

Still need help to autopopulate a form

If I were to tell Access my problem in human speak, this is what I would say:

When I choose the CustomerID value from combo box on frmInvoices, I want you to go to tblNewInvoiceNumbers and place that value in CustomerID field as new record,(and enter date in DateCreated, too). Then, I want you to get the new invoice number that was created and put it on my frmInvoices in InvoiceNumber field.

Thanks, Noreene