Filter Checkboxes

[lewis1682]

Hey again,

I am running a little code to filter some results on my form. I have sorted out filtering a combobox and textboxes, but not a checkbox. Here is some code I am using for a textbox:

    If Not IsNull(Me.txtFilterPostalCode) Then        strWhere = strWhere & "([PostalCode] = """ & Me.txtFilterPostalCode & """) AND "
    End If

At the end I have Me.Filter = strWhere

To filter the checkbox called checkFilterAGM I have tried to use:

If Me.checkFilterAGM = -1 Then        strWhere = strWhere & "([AGM] Me.checkFilterAGM = true & )"
    End If

But it didn't work. The field name is AGM. Thank you.

[pbaldy]

More like:


strWhere = strWhere & "([AGM] = true)"

[lewis1682]

Wow that simple, thanks for the quick reply,

[pbaldy]

Happy to help!