Text Boxe Issue

[wes028]

Trying to compare 2 text boxs on a form and see if there value's are equal. If they are, clear the value in the one field. If there not equal, display message that values don't match.



What I've tried so far.

 
If Me.txtSe.Value <> Me.ReSNum.Value Then
         Me.txtSe = ""
    Else
        MsgBox "Values Don't Match", vbCritical, "Search Error"
        'Me.txtSe = ""
    End If

[Husseintech]

i think its good idea thank you and go forward

[wes028]

Solved. Had to change format on both text boxes to general number.

 
If Me.txtSe = Me.ReSNum Then
Me.txtSe = Null
Else
MsgBox "Values Don't Match", vbCritical, "Search Error"
End If