Let's say you have a check box set with these values: apple Pear Orange
And you need a test to see if "Pear" was selected:
Not IsEmpty ( FilterValues ( YourTable::CheckBoxField ; "Pear" ) )
will be true if "Pear" is selected.
I was working from an older User's Guide (version 6) and wasn't even aware of the FilterValues function.
Thanks for the help, worked like a charm!