Multiple Filters on form load (1 Viewer)

helloy guys, please help... i know this is simple but i tried a few things but nothing works. i want to load a form with two or up to 4 filters. with one im okay but adding another filter i don't know how to do that. here's the code

Me.Filter = "Department = 'East'"
Me.FilterOn = True

that's one filter on load event of a form. and it does work nicely.

but i want to add the following

"Department = 'East"
"Division = 'Blue'"
"Unit = 'Five'"
"Area = '2nd Floor'"

how to add them to my filter? thank you so much in advance...

use And in your filter:

Me.Filter = "Department = 'East' And Division = 'Blue' And Unit = 'Five' And Area = '2nd Floor'"
Me.FilterOn = True

thanks! I used that earlier, but I see now that I missed a freakin quote. thank you buddy!