Multiple selections in Form

On a form called "Event Grab kids Form",
I am trying to narrow a combo box called "Kidz" down by selecting

a grade and a gender from 2 list boxes called

Grade Selector & Male Female Selector respectively.


I have gotten this to work by building
[Forms]![Event Grab Kids Form]![Male Female Selector]
in the criteria section of the query builder.

My next step was to be able to at the same time select F or M,
Select them both, so that if I needed to see all the kids then I could.

I tried settting the multiselect setting to simple & extended, but then I read that
when this is done, the value returned will always be null.

Help also suggested using the ListIndex property, but I got lost.

Wondered if any had any ideas.

Peace
Chad Cromer

This may sound a little silly, but Ive gotten around that
problem by using a wildcard (*) to pull up any/all
matching records.

So on your form, you could either type in M, F, or *
manually, and bring up the selected records.

That is an incredible idea, but I could not get it to work whether I used
* or (*) or "*"

my syntax is
M;F;*

I tried a simple query in which this was the only return, but all I got was
blank. Wonder what I am doing wrong.

Peace through the Son
Chad


"Eddie" wrote:

This may sound a little silly, but Ive gotten around that
problem by using a wildcard (*) to pull up any/all
matching records.

So on your form, you could either type in M, F, or *
manually, and bring up the selected records.