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

 

[danomaniac]

try adding a new column to your query as follows:

in the FIELD box type: IIf(IsNull([Forms]![form1]![Combo])=False,[YourFieldNameHere]=[Forms]![form1]![Combo],[YourFieldNameHere] Like "*&quot

unclick the SHOW box and set your CRITERIA to <>False