Search results

Well, DUH!! I didn't even think of that! I am going to try that. Thank you so much!

I said that my control source was tblinvoices but I meant my record source. I tried to do this with code but can't remember how anymore. I can do a Docmd and get the tblinvoicenumbers open to new record, but can't remember how to tell it to place frmInvoices.customerid.value into the...

I have a form "frmInvoices" that is used for entering and printing invoices. This form's control source is "tblInvoices". My problem is: When I choose customerid in combobox on form, I need it to go to "tblInvoiceNumbers" and enter customerid in the field in the table, get the new invoice...

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...

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...

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

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