hello there. is there a way to filter a combo box items like this:


tbl_employees (ID, forename, surname)

cbox_1: show all employees
cbox_2: if employee_5 is selected on cbox_1 it wont be available on cbox_2.

thanks in advance.

edit: how do i delete my previous thread? (i didn't see the "MS Access FAQ", only found it after a posted, sorry)