Form filter using two criteria 1

[vanders]

I would like to filter a form based on the value of two controls withing the form. I can achieve this for one control using the format,

Me.Filter = "responsibility=" & [cboEmpName]

However when I try to introduce the other criteria, which is a check box, such as

Me.Filter = "responsibility=" & [cboEmpName] And "ckbClosed=" 'False'

I get the message "Type mismatch"

Your help would be greatly appreciated.

 

[coco86]

Try this

Me.Filter = "responsibility='" & [cboEmpName] & "'" And "ckbClosed = False"

-Coco

 

[vanders]

Thanks for the suggestion Coco but still get a type mismatch message. By the way the [cboEmpName] is a numeric if that makes any difference.

 

[coco86]

does
Me.Filter = "responsibility=" & [cboEmpName] & " And ckbClosed = False"
work?

-Coco

 

[vanders]

Thanks Coco that works, your a star.