Thanks for taking the time to reply wayne,
I tried using cboDept.value and just cboDept but i still get the same error.
I got rid of the error but i dont know how. I copied and pasted the code and controls to a new form and now it works fine. The code and controls are exactly the same, except...