Is there a way to embed multiple drop down selection boxes in a Where/If statement? Adding 2 Where fields with &Parameter options yields an error when attempting to run.

Are you trying this in the same WHERE statements or are they each in their own WHERE? Also, it appears that you are relying on autoprompting to create your controls. If you want something a more sophisticated than the default, create launch pages for them. Autoprompting just doesn't cut it for anything but the simplest stuf (well, I guess that's my opinion)