ApplyFilter error

[simon1974]

I am using the following syntax to filter on a checkbox field:

DoCmd.ApplyFilter , "[Report] = 'Yes'"

I get the following error when the code executes:

Runtime error 2501
You used a VB method but then clicked cancel in a dialog box. (which I haven't done)

Any suggestions?

 

[raymondo]

I may be mistaken but in your code
DoCmd.ApplyFilter , "[Report] = 'Yes'"
if [Report] is a checkbox then its value is a boolean and 'Yes' is a string. Try it without the single quotes around Yes.