I don’t know what went wrong to my code I still having a error in my visual basic project, I done my very best the error is still there here is the error (data type mismatch in criteria expression) …… need help please!!! im using VB6 as programming language and access 97 as database

hey im good the problem is solve

The line that doesn't "work" is passing in a string variable. The line that "works" is using a numeric value.

I'd look in to that if I were you.