Getting (all) employee to show in report

[IFORD]

I have a report that runs off of parameters in a query which is: [FORMS]![frmSalesmanCustomerList]![EMPLNO]on the form the [emplno] is a combo Box if I would like to see information on one employee it is working. But I would like to be able to see (ALL) employees if possible. I can add a (ALL) to the combo Box. But that does nothing for my query. And my report print error.

Thanks Irene

 

[batteam]

You could have some code behind your report's On_Open event that looks at some 'flag' field on your form. If this 'flag' field indicates that your user wants to see all employees, then have the code behind your report act on this and have it change the report's Record Source to a query that doesn't have the single Employee No. in the criteria row, but instead shows all employees.

Hope this helps.

 

[CosmoKramer]

Irene,

Check out faq702-4538

I'm CosmoKramer, and I approve this message.

 

[IFORD]

Thank you both, but I found that if I change my code on the query to read:

[FORMS]![frmSalesmanCustomerList]![EMPLNO] or [FORMS]![frmSalesmanCustomerList]![EMPLNO]is null

And on the form I leave [EMPLNO] blank I get ALL employees

Thank you both again

Irene