button to table checkbox filter on form

[Ruegen]

I have a form where I want to filter or unfilter using buttons any fields that are true or false

so

me.filter = [ConfirmationSent2nd] = true
me.filteron = true

that sort of thing

not sure about the vba for that...

[pbaldy]

Right idea, but the filter string needs to be enclosed in quotes.

[Ruegen]

me.filter = "ConfirmationSent2nd = true"
me.filteron = true

Like so?

Update - it works. Thank you so much!

[pbaldy]

Happy to help!