Need help creating a filter in a subform located on a tab control page 1

[Johnnycat1]

I am trying to create a button to filter data on a subform located in a tab control.

The subform's query has a field with an expression where if certain check boxes are checked, the expression produces "1". If none of the check boxes are not checked, the expression produces a "0".

This is the code that I am trying to use to filter the subform based on the [RequiredInfo] 1 or 0.

Private Sub Command138_Click()

With Forms!FrmFixtureDetailing!FrmFixtureDetailingRequiredInfo.Form
.Filter = "[RequiredInfo]='" & 1 & "'"
.FilterOn = True
End With

End Sub

I am getting error 2001 "You cancelled the previous operation"

This error seems to be a red herring.

Any help???

 

[Remou]

Why not:

.Filter = "[RequiredInfo]=1"

?

 

[Johnnycat1]

Thanks Remou that did the trick.