Type mismatch error

The following is SQL query has given me a type mismatch error.


strSQL = "Select * From CALIBRESULTS where InstrumenNumber = " & "'" & Form3.Label4.Caption & "'" And idnumber = "'" & Form3.Text51.Text & "'"

I think the problem is that instrumennumber field is a string while the idnumber field is an integer.

Any thoughts?

Also, can you please tell me if the "" and ' marks are in the correct place. I always mess up on that one.

Thanks

If what your say is the case, then it should look like:

VB Code:

strSQL = "Select * From CALIBRESULTS where InstrumenNumber = '" & Form3.Label4.Caption & "' And idnumber = " & Form3.Text51.Text