IF, ELSE STATEMENT NOT WORKING

[laman]

I'm using the following code to do searches with numeric and text fields.

Private Sub Command12_Click()
If " & field & " = TUBE_NO Then
strSQL = " Select * from master WHERE " & field & "" &_ operand & "" & criteria & ";"
Else
strSQL = " Select * from master WHERE " & field & "" &_ operand & "'" & criteria & "';"
End If
Me.result.RowSource = strSQL

End Sub

It skips to the else statement even though the selected field is TUBE_NO.
ANY THOUGHTS
THANKS,

 

[JohnYingling]

Do you mean that TUBE_NO has literally
the characters " & field & " i.e.
"Space Ampersand space f i e l d space ampersand space" in it?
I believe that if IF ELSE is working. Re-examine what you think
If " & field & " =
is supposed to do.

http://www.VBCompare.com

Compare Code (Text)

http://www.VBSortGen.com

Generate Sort in VB or VBScript

 

[loveTech]

try this
If "field" = TUBE_NO Then

notice i take the &&'s out...