I have a situation where i need to be able to set a filter on my form and can't figure out how to do it, newbie that I am.

I have a data combo box of department numbers created from an sql statement in the recordsource property. I also have a listbox of subdepartment numbers created by an sql statement in it's recordsource property. The information in both these objects comes from different tables which share one key field, the department number. I want the listbox of subdepartment numbers to be filtered and to refresh itself based on the department number selected in the data combo box.

Any comments that could point me in the right direction would be appreciated.

Marie