check for change to field value

[Guest]

I know the "dirty" attribute can be used to see if a form's content changed.
Is there a similar attribute that I can use top evaluate whether a specific
field onthe form was changed?

Thanks,
Dan

 

[Allen Browne]

Compare its Value to its OldValue.

Like this:

With Me.[NameOfYourControlHere]
If (.Value = .OldValue) Or (IsNull(.Value) And IsNull(.OldValue))
Then
MsgBox "No change"
Else
MsgBox "Changed"
End If
End With

 

[Guest]

Thank you Allen ......

Compare its Value to its OldValue.

Like this:

With Me.[NameOfYourControlHere]
If (.Value = .OldValue) Or (IsNull(.Value) And IsNull(.OldValue))
Then
MsgBox "No change"
Else
MsgBox "Changed"
End If
End With

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I know the "dirty" attribute can be used to see if a form's content
changed.
Is there a similar attribute that I can use top evaluate whether a
specific
field onthe form was changed?

Thanks,
Dan