vba if statement returns false
Posted on 2012-03-13
I'm using the if statement below to modify the string strMySql.
strMySQL = "Update Part_Serial_Number Set "
'build sql statement from text boxes that have data
If Me.txtPCBoard_Lot_No1 <> "" Then
strMySQL = strMySQL & "[PCBoard_Lot_No1] = " & str_txtPCBoard_Lot_No1
When Me.txtPCBoard_Lot_No1 is empty, strMySql is being set to "False". I would expect it to just leave strMySql as it was.
I don't recall seeing this before. Any ideas?