Access 2007 - Filter Combo Box options
Posted on 2011-02-18
I've got a form that is bound to a source that basically represents one record at a time with primary key being ProjectID. Inside this form I have a combo box that allows me to select different projects. I've got code written that automatically will update the record the form is bound to based on the selection of the projectID combo box.
Also in this form I have a sub form that is a continuous form and shows a listing of records. One of the fields in this form is bound by a combo box having a row source built with quite a few options. I need this list of options to be filtered by the project that is selected in the parent form. I have the Link Master Field and the Link Child Field both set to ProjectID, I'm just not sure how to utilize that projectID to impose a filter on the combo box in the sub form.
If I need to say anything else to provide further clarification just let me know.