how to show data only from selected combo boxes ?

[phool4fool]

I've created a form where I've used 5 combo boxes all are working fine & i'm getting all information.
Following are the combo boxes:
City - School - Class - Gender - Grade
--All - --All - --All - --All - --All
--city1 - --school1 - --class1 - --Male - --A+
--city2 - --school2 - --class2 - --Female - --A

See, I've combo for city where I've 'All, city1 & city2' in drop down & same for others.
I want the following result:
If I select city1 from City & All from Gender, it should show only the data according to the selected combo boxes. But, here I'm getting the related information but all other columns are showing but with no data. So, what should I do to only show relevant columns in output not all columns with no data in it.
Really need help?
Waiting for a solution....!!!

[June7]

Is this what you are trying to do
http://datapigtechnologies.com/flash...earchform.html
http://datapigtechnologies.com/flash...tomfilter.html

How are you handling a selection of 'All'? I expect isn't working because none of your fields have value 'All' so nothing matches that criteria. How did you get 'All' into the combobox RowSource - a UNION query?

[phool4fool]

everything is working... the only thing I want is:
what if I don't want to search for Grade & I only choose other combo boxes. It also show Grade information which I don't want to see

[orange]

If you don't want to see values for a particular field, then remove that field from the SELECT query underlying your Search routine.

[June7]

Why is showing the data an issue?

If you don't want to show a field for which no criteria is input into combobox, then as Orange said, modify the SELECT query that references the comboboxes as parameters.

Another approach would be to have expression in query to calculate an alias field name:

StudentGrades: IIf(IsNull(Forms!formname!comboboxname), "", [Grades]))

Now put combobox paramater in the criteria under this column. The fieldname will still show but no data if combobox is empty.