Filter Form

[mark curtis]

Please look at the attached.

The form is a subform filtered by projectid. What I want to do is select the Type and then filter the form where all the selected type for that projectid are returned and if there are none then msgbox them?

 

[llkhoutx]

Put a combo box, named cboType whose record source includes all possible types, at the top of your form. This can be a 1 column table or a value/list.

On the combobox afterupdate event, reset the fom rowsource and requery the form, e.g.

me.recordsource="SELECT * FROM YOURTABLENAME WHERE TYPE = '" & cbotYPE & '"
me.requery

Note that '" is tick mark then quote.