Thank you so much! I am using this as a form for inputting records, as well as for filtering. UserForm2 is used so that each department only sees their own records (this isn't a security thing as much as a practicality thing or else I'd use something more secure).

I haven't used dependent comboboxes yet, but that sounds like a simpler way to code this form than what I am currently doing. I will definitely look into them. Thank you!!