Data type mismatch on recordsource

[chibbie23]

Im a 3rd year computer science student. I am using adodc on my project, i dont know whats wrong, I'm trying to set the recordsource of my adodc, and trying to filter my database with a criteria that has an integer datatype. . .i think i have tried everything:

me.Adodc1.Recordsource = "Select * from tbltrans where Service_Tag = '" & me.Text1.text & "' "

me.Adodc1.Recordsource = "Select * from tbltrans where Service_Tag = '" + val(me.Text1.text) + "' "

me.Adodc1.Recordsource = "Select * from tbltrans where Service_Tag = ' me.Text1.text ' "

when i try to debug my code, i reaized that it could get the value of of the textbox or the variable, but it always say "Datatype mismatch" . . .
i need some help,

[vb5prgrmr]

If it is a number then don't use the single ticks (') to surround your value...

strSQL = "SELECT * FROM tablename WHERE numericfieldname = " & Val(Trim(Text1.Text))
 

Good Luck

[chibbie23]

It worked. . .i'm really ;lucky to have discovered this site. . .
hehehe