The fastest and easiest way is:
CurrentDb.Execute("querynameOrSQLString"), dbFailOnError

The reason is it going directly to Jet.  Just for fun, compare the above to
DoCmd.RunSql("querynameOrSQLString").  This method goes through Access and
runs much slower.

As to the parameters issue, my favored approach it to create an SQL string
without the Where condition, then add the Where condition based on user
selections.