Something's wrong with your criteria.
When you check SPEEDS on your form (forms!frmcriteria!speeds) I assume you are checking something in the SPEEDSTUDY field, but what, is it anything that has a value? does the checking the checkbox on frmcriteria mean that you are looking for any record with a value in that field:
SPEEDS -> SPEEDSTUDY
TUBES -> TUBECOUNT
MANUALS -> MANUALCOUNT
OTHER -> OTHERTYPESTUDY
If so you'd want a query more like this:
Code:
SELECT tblTrafficCount.CountID, tblTrafficCount.SR, tblTrafficCount.MP, tblTrafficCount.SpeedStudy, tblTrafficCount.TubeCount, tblTrafficCount.ManualCount, tblTrafficCount.OtherTypeStudy, (Date()-[countdate])/365.25 AS age, IIf([forms]![frmcriteria]![speeds]=-1 And Not IsNull([speedstudy]),1,IIf([forms]![frmcriteria]![tubes]=-1 And Not IsNull([tubecount]),1,IIf([forms]![frmcriteria]![manuals]=-1 And Not IsNull([manualcount]),1,IIf([forms]![frmcriteria]![other]=-1 And Not IsNull([othertypestudy]),1,0)))) AS ShowSpeed
FROM tblTrafficCount
WHERE (((tblTrafficCount.SR) Like [forms]![frmcriteria].[sr]) AND ((tblTrafficCount.MP) Between [forms]![frmcriteria].[startmp] And [forms]![frmcriteria].[endmp]) AND (((Date()-[countdate])/365.25)<=[forms]![frmcriteria].[age]) AND ((IIf([forms]![frmcriteria]![speeds]=-1 And Not IsNull([speedstudy]),1,IIf([forms]![frmcriteria]![tubes]=-1 And Not IsNull([tubecount]),1,IIf([forms]![frmcriteria]![manuals]=-1 And Not IsNull([manualcount]),1,IIf([forms]![frmcriteria]![other]=-1 And Not IsNull([othertypestudy]),1,0)))))=1))
ORDER BY tblTrafficCount.MP;