Hi.
I have 2 combo boxes in my form. One Combe box's row source is connected to 'Systems' table and one Combo box's is connected to 'SubSystems' table. I need when I select an Item from 'System' combo box, 'Subsystem' combo box will automatically filtered based on which 'System' is selected.
Notes: Tables Systems and SubSystems have Relation together(One to many).
I've tried with Control Source and Criteria in row source window.
I'm using Microsoft Access 2010.
Thank you.