Hi all
How are you?

I have a school data base with a form has 4 combo boxes (Country, Gender, Courses, and Supervisor), and 1 button.
For example, If I select UK from the Country Combo box, and click the button, a report will be viewed and it will contain all students from UK. And the same for the other combo boxes.

I want when I select Male from the Gendar combo box, the report to show on the top Search Results for: "Male"
Also, when I select David from the Supervisor combo box, the report to show on the top Search Results for: "David"
And so on for the other combo boxes.
How can I do that??

Thanks in advance

not tested:
- place an unbound textbox on your report.
- in the control source type: =Forms!frmYourSearchForm!cboName.Column(1)
- notes: your search form has to stay open; you might have to change the column number; assumes you have a different report for each combo.

Thank you Mr. wazz.... It works.
I want to put an if statement in report load.
I want if I select Male from the Gendar combo box to show me Search Result for "Male".
I mean "Male" to be visible if I select, and invisible if I don't select it.

Thanks alot