I have a form (frmInvoices) used to enter new invoice data. It's control source is tblInvoices. But on my form, I have 3 fields to pull data from: (tblcustomer.customerid) and (tblnewinvoices.id; customerid; and datecreated) I can't figure out how to populate datecreated and id from tblnewinvoices whenever I enter customerid. One problem is that tblnewinvoices.id is an autonumber used to create invoice numbers incrementally. And it has to have customerid entered before it will give new number. I know it is simple, but I have been out of Access for 6 years and can't remember anything!
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!