Form Filter Question

[lskuff]

I have a question about applying a form filter with a button. I have a form "Seminar" that has a field "Completed" with a check box. I want to add a button to the bottom frame which when clicked only shows the Seminars that have the check box clicked. I also want the text on the button to change from "All" to "Active" when it is clicked. Anyone have any help? Thanks

 

[namliam]

if me.mybutton.caption = "All" then
me.filter = "[Completed] = True"
me.filteron = true
Me.MyButton.caption = "Active"
else
me.filter= ""
Me.filteron = false
me.mybutton.caption = all
endif

Dunk that into your "on click" of the button, change mybutton so match your buttons Name Et Voila....

Regards

The Mailman

 

[lskuff]

Thanks! That worked perfectly.