Multiple Filters on one subform

[dgaller]

I currently have code on click to filter a subform based on a combo box and it works great. (see below)

Me.[task detail subform].Form.Filter = "[Person Responsible] =" & Me!Combo107
Me.[task detail subform].Form.FilterOn = True

The problem is I also need to only show records that have a 1, 2 or 3 in the status field on the same report.

How do I join that to the above filter?

 

[KenHigg]

Just wrap the pcs in parens and joing them with 'and'.



ken

 

[dgaller]

I tried doing :
Me.[task detail subform].Form.Filter = "[Person Responsible] =" & Me!Combo107 And Me.[task detail subform].Form.Filter = "[status] =1" but I get a type mismatch error. Status is a field I have a look up to. (Example 1 = open)

 

[KenHigg]

Me.[task detail subform].Form.Filter = "([Person Responsible] =" & Me!Combo107 & ") And ([status] =1)"

or

Me.[task detail subform].Form.Filter = "([Person Responsible] =" & Me!Combo107 & ") And ([status] ='1')"


???
ken

 

[dgaller]

It worked. I truly appreciate your help, Ken!

 

[KenHigg]

Glad to help