COMBO box selection filters out a list of contacts

[accessnewby]

Hello,
First time Access user.

I'm trying to set up my own form for my customer contacts.
I have TABLE A that lists general customer information.
I have TABLE B that lists customer branches (each customer has multiple branches).


I have a combo list set up so that if I select a customer name, the rest of the form populates with the customer general information.

Is there any way I can filter out a list depending on what customer is selected?
I only want to see the branches of the customer I've selected on the COMBO box.

Thank you

[orange]

see this tutorial

[June7]

If you want cascading comboboxes, review http://www.datapigtechnologies.com/f...combobox2.html