[RESOLVED] Very Strange Select Error

[whythetorment]

guys i have a strange error....ok well i know what the error means but dont why its happening. my code is:

sstr = "select VideoTape.DateAdded, VideoTape.Issues, VideoTape.Barcode, VideoBase.Title from VideoBase, VideoTape " & _
           "Where VideoBase.Code = VideoTape.Base " & _
           "AND DateValue(VideoTape.DateAdded) Between " & "#" & DateValue(aCrit1) & "#" & _
           " AND " & "#" & DateValue(aCrit2) & "#" & _
           " AND VideoTape.Issues <= " & aCrit3 & _
           " AND VideoTape.Deleted = No" & _
           " AND VideoBase.Deleted = No" & _
           " Order By VideoTape.DateAdded"

then to execute it i say

Set rsx = Datacc.GetVideoIssues(DTPicker1.Value, DTPicker2.Value, Text1.Text)

simply enough yes? yes......now dtpicker1 and 2's values are fine. text1 is what i use to specify the issue amounts. now if i enter values 1, 2, 3 etc. to 7 it works perfectly. then i enter value 8 and it gives me a Data Type Mismatch error in criteria expression. then i enter 9 - whatever and it also works perfectly.

anyone know why it bombs out only on 8? i checked in the database and there are issues that went out 8 times. so its very very strange.