Hi, I am fairly new to Access. I have created a main form and one of the fields in the main form has a drop down list. I would like to have a different field in the subform auto populate depending on what the user chooses in the drop down list of the main form. Can anyone explain how I would do that?
Thank you!