How would I create a form in Access where you enter an account number and then the rest of the information populates on the form? I am guessing a combo box to enter/search for the account number and then some VBA when you exit the box?
I have a few fields: account number, customer name, phone number, status.