Hi Duane- To answer your questions: 1; The job number field is not in the record source of the report. It resides in its own table called 'tblJobNumbers'. 2; I placed the combo box on the same form as the report option, and that works fine, but the next step should be to 'click' a button that previews the report and it showing the selected job number on the report. 3; I understand about needing the combo box on the form. 4; The SQL of the 'qryRouteSheet_1stofMonth-Phoenix' is:
SELECT DISTINCTROW tblLocations_Phx.Loc_ID, tblLocations_Phx.[Main Zone], tblLocations_Phx.[Main Seq], tblLocations_Phx.Name, tblLocations_Phx.Address, tblLocations_Phx.City, tblLocations_Phx.Zip, tblLocations_Phx.Category, tblLocations_Phx.Phone, tblLocations_Phx.Hours, tblLocations_Phx.[X-Ref], tblLocations_Phx.[Apt Guide], tblLocations_Phx.[AZ Golfer], tblLocations_Phx.Fitness, tblLocations_Phx.[FIT RK], tblLocations_Phx.[AG(I)], tblLocations_Phx.[AZG(I)], tblLocations_Phx.[FIT(I)], tblLocations_Phx.Pays, tblLocations_Phx.Fuel, tblLocations_Phx.OSA
FROM tblLocations_Phx
GROUP BY tblLocations_Phx.Loc_ID, tblLocations_Phx.[Main Zone], tblLocations_Phx.[Main Seq], tblLocations_Phx.Name, tblLocations_Phx.Address, tblLocations_Phx.City, tblLocations_Phx.Zip, tblLocations_Phx.Category, tblLocations_Phx.Phone, tblLocations_Phx.Hours, tblLocations_Phx.[X-Ref], tblLocations_Phx.[Apt Guide], tblLocations_Phx.[AZ Golfer], tblLocations_Phx.Fitness, tblLocations_Phx.[FIT RK], tblLocations_Phx.[AG(I)], tblLocations_Phx.[AZG(I)], tblLocations_Phx.[FIT(I)], tblLocations_Phx.Pays, tblLocations_Phx.Fuel, tblLocations_Phx.OSA, tblLocations_Phx.Zip
HAVING (((tblLocations_Phx.[AG(I)]) Is Not Null)) OR (((tblLocations_Phx.[AZG(I)]) Is Not Null)) OR (((tblLocations_Phx.[FIT(I)]) Is Not Null))
ORDER BY tblLocations_Phx.[Main Zone], tblLocations_Phx.[Main Seq];