i have experienced like this one too. the problem was the data type. How come??? let see your code below : stSQL = "Select * from testbackup Where barcodeid = '" & Value & "'" if we see at barcodeid = '" & Value & "'" , we can say that barcodeid is string data type. But it's possible in your datasource, the barcodeid is integer.. so the solution is remove ' charachters, and it will be like this: stSQL = "Select * from testbackup Where barcodeid = " & Value -- modified at 7:43 Friday 4th August, 2006