I have all the myriad parameters for some canned queries in a lookup table. In some of the instances, the Branch must be specified and others it is blank. In some instances I am looking whether the Customer exists or not.
Set DB = CurrentDb()
Set McP = DB.OpenRecordset("tbl_APAP_Param")...