How to use setfilter with access report based on combox?

Question

I have a form (form1) . I have a report (report1), and this report has 4 fields:

• ID
• NameEmp
• dataHiring
• Salary

I need to filter this report based on user choices from a combo box (named cboname) in form1.

How to set a filter for report1 that contains only NameEmp based on cboname?

I already tried to use this VBA code:

DoCmd.Setfilter Where condtion :- [NameEmp]= forms!Form1 [cboname]
Event: On Open_Report1

thanks a lot.

Answer 1

make a query to the report and under ID criteria put [forms]![form1]![cboname]

thanks for helping, but still that is not what I want because if I want to build many combo boxes, that's mean I have to build many queries for many combo boxes. and Second: see the example down : if I build a query with multiple fields let say ( and I will put your criteria in front of each field ):

1. ID [forms]![form1]![cbonID]
2. NameEmp [forms]![form1]![cboname]
3. dataHiring [forms]![form1]![cbodataH]
4. Salary [forms]![form1]![cboSal] the access will run the query according to criteria, now I understand that clearly, but, what if the user want all employee name with hiring data before 2012. what if also the user choose all salary above 3000$ with all information (ID, NameEmp,dataHiring).. and so on. Multi-choices for one report, that's mean a many queries!!!
   all I want to set filter and if the user does not choose anything then remove applied filter.