Combo Boxes

[Frank72]

Hows it going

This is about the 10th time i've posted this question regarding leaving a combo box unselected so that as a parameter it will select all from the field.So far i've had many responses, many thanks, but unfortunately none seem to be working. I'm sure its got something to do with putting IS NULL in with the criteria box of the query.

I have 3 combos; gender,location and model each a parameter for a query, can i leave one , two or even all three empty in order to take the filter out and therefore select all records (all male, or all loc tec.)? They are all single column combos.

There has to be a simple way of doing this.
Any suggestions pleeeeeeeeeeease give us a shout
thanks alot

Frank

 

[930driver]

If you put 'IS NULL' in the criteria for your query you will get only records where that field IS NULL. Since you are looking for 'all' for a particular field you would use 'Like *' for a text field or 'NOT IS NULL' for a numeric or date. You might have to experiment. For instance if your numerics default to zero you might need '> 0' to get all for that field.
"The Key, The Whole Key, and Nothing But The Key, So Help Me Codd!"