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?

Joe,

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

Regards,

Don

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].