Matching A Value

[Eranka]

Hi


i want to match a textbox value with value in table, if the textbox value matches the table value then update the data else popup a message box "value not matched"

Ex:
If(Me.Text10 != tblUser.ID) Then
MsgBox "Value Not Matched"
Else


Updatequery


i tried above but not working. how to do this part?

[ranman256]

If Me.Text10 = tblUser.ID Then
   Updatequery
Else
     MsgBox "Value Not Matched"
end if

[Eranka]

HI


tried the above code, but not working. i tried below code as well.

Dim Ic As String

Ic = DLookup("NIC", "tblUser", "ID = " & Me.UserLogin)

If (Me.Text10.Value <> Ic) Then
 MsgBox "Please Enter Correct NIC Number" 
Else 
 Update Query

is the above code correct?

[orange]

Can you step back and tell us in plain English what you are trying to accomplish?

Clarify UserLogin, ID??

The syntax for If statement

If (some condition) Then
'if true stuff here
else
'if false stuff here
End IF