On my MDI I have two combo boxes, department and supervisor. I need code some code help. . . .

In Access I have two tables, [Department] & [Supervisor]. In VB want to be able to select a department and then have the second cbo reflect the supervisors for that department. How can I make it do that? Please be specific. Thank you.