Allow combobox selection to populate text fields (with data from multiple related tables) in a form (MS Access 2010) ?
Posted on 2013-02-04
I am currently building a DB in MS Access 2010 and I am having some trouble with the forms.
I have built the DB with many related tables. I have now created a form that contains a few fields with data from various related tables. The form contains a combobox where a customer's full name can be selected and their related information will populate the fields within the form.
I am having trouble formatting the combobox so that when the client using the DB selects a customer's name in the combobox, it will display the customer's information in the text fields on the form.
I am new to MS Access and have no prior DB experience.
I am grateful for any help pertaining to this issue.
Thank you so much !