do you mean that when user fill up the textbox and if this is same with earlier saved item in database table , then update operation should not take place otherwise update record ?
if this is the issue then use following code
rs.Open "select*from Employees where Employees_IdNo='" & Trim(txtID.Text) & "'", cn, adOpenKeyset, adLockPessimistic
If rs!Lastname = txtLastname.Text Then
MsgBox "Cannot Update !"
Set rs = Nothing
rs!Lastname = txtLastname.Text
now you can adjust with above code
hope this helps you . . .
It will update every time you click on your cmdUpdate button because you are telling the form to update. Add a cmdCancel button to your form. If the user do not want to update, they can click on cancel and then exit the form...
''Write some code to clear all text boxes...