Find Issue: 1 of 6 checkboxes returns All

[Joe S.]

I have a VERY basic database with tables for my music students' info and the school-owned instruments.

In the Student table, there is a checkbox set from a value list which displays the different ensembles that are offered.

When I perform a find by checking "Band A", I get those 42 kids. When I find by checking "Jazz Band", I get those 29.

But, when I find by checking "Band B", I get all records. I should only get 49 of 92.

I've already verified my value list to be sure it's error-free. I've unchecked and rechecked a few kids into Band B (and the inverse for some of the Band A kids). There are a couple who do both, so radio buttons are out.

Any idea what else might be causing this?

[dreamingmind]

Joe,

You're probably going to have to post the file to get resolution.

Regards,

Don

[comment]

when I find by checking "Band B", I get all records

Yes, because all your records contain the word "Band" AND they also contain a word that begins with "B" ("Band").

See here for a more detailed explanation:

http://fmforums.com/forum/showtopic.php?tid/193795/

Possible solutions:

• Remove the word "Band" from your ensemble names;

• Search for exact values (by using quotation marks and/or equal signs);

• Use a relationship to find the records - i.e. match a global field (using the same value list) to the Ensembles field. This will perform an OR find when you perform Go to Related Record [show only related records].