'Select all' symbol in a listbox 1

[Frank72]

Hows it going

I have a few listboxes for gender location and model selection and want one of the options in the gender box to select all m, f and unknown. I currently just have an asterix for this and thought that maybe i could use this in sql or in some way to make the criteria select all genders.
Is there a quick and clever way of doing this?
Any suggestions gratefully received

thanks

frank

 

[GK22]

Make a query. In the gender-field (m/f/unknown) you type
LIKE * & forms![formname]!cbo1.
If you select nothing in the combobox, all persons come up
formname = form where combobox is in
cbo1 = name of the combobox

Hope this make you troubles gone

Gerard

 

[Frank72]

Thanks thats just what I needed!

Frank

 

[Frank72]

Actually sorry thast doesn't seem to work just draws a blank any other suggestions?....anyone....help!! I thought this would be a feature on access but i can't seem to find any way of getting to work.

Thanks

Frank

 

[tomschafer]

You can not directly reference the values selected in the List Box. What Gerard posted will work if you are using a Combo Box. In order for this to work you would need to use VBA to dynamically build a query based off the List Box.