cross over a criteria from a querie.

[Guest]

Hi. I have a querie that list only employees from a specific Departement. I
have a text in the Swithboard that indicates the specific Department. Imagine
that in that textbox appears the name IT, that means that only appear people
from the IT Department. That's all ok and till here no problem.

I need that for Human Resources appears all employees, imagine that when the
Department is HR the criteria turns off, so that means that HR department can
see all employees.

Is it possible??

Thanks in advance,
Marco

 

[Guest]

If I understand it you want a new button on the switchboard that is for HR
and shows all data?

If that's the case you don't need to run it off the same macro or a macro at
all. Try inserting a new command button in the design view that opens a dif
query made for the HR people. That query can show anything you want.

That might not be what you were looking for but, that's how I saw it.

 

[Guest]

Hi. Can you explain me better with an example.

Regards,
Marco

 

[Guest]

Hi John. Weel, I already had tried with the quotations mark