I am trying to figure out how to set up a form in Access to automatically fill in 2 fields (Region # and Store Name) based on the Store number which is entered in another field.
So whenever a user types in a store number, the store name and region number fields automatically populate.
If needed, I can send a copy of the database so someone can view it and show me what I need to do. I cannot find any step-by-step instructions anywhere on how to do something like this.
Thank you for any help you can provide.