I am sorry to take the liberty to email you directly, but I am in a really tight situation that I cannot seem to figure out. I am creating a database in MS Access. I have created several tables that I would like to link with each other. I created a form called users, within this form there are several fields that I would like to be autofilled the moment I choose an option from a combo box. (i.e. there is a table called Location, within this table I have the following fields: location name, address, city, state and zip code/postal code. I have entered three different locations. Corporate, Spaid and Remote. Each location have different address information. Then I went into my User table and created a combo box named location, I want to be able to choose one of the three locations above, and have the fields, address, city, state and zip code/postal code automatically filled based on the chosen location.
I have no clue how to do this. Can you please help? Also, do I need to create the fields address, city, state and zip code in the User form in order to be autofilled? Please advise.
Thank you so much.