Combo by selecting "All" or "Specified" Department

[Bill]

Hi,

I have a list of department using combo dropdown. I want to add "All
Departments" on top of few departments on the list. When I want to select
"All Departments", it will give me all departments. If I want to select one
department, then give me one department on the report.

Here is the code and you might help me how to add "All" to the line of the
code.

strDept = "='" & Me.cboDepartment.Value & "'"

Your help would be much much much appreciated.
Thanks

 

[stefan hoffmann]

hi Bill

Here is the code and you might help me how to add "All" to the line of the
code.
Your help would be much much much appreciated.

http://support.microsoft.com/?kbid=210290


mfG
--> stefan <--