By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,987 Members | 997 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,987 IT Pros & Developers. It's quick & easy.

Dirty property

100+
P: 110
Hi,

I know aboutthe dirty property that returns about a bool if the reocrd has changed....is there any such option or code for controls?

so a dirty property but for indivisual controls on a form instead of the hwole record...ideas?
Mar 14 '07 #1
Share this Question
Share on Google+
3 Replies


missinglinq
Expert 2.5K+
P: 3,532
Maybe something like this:

[HTML]Private Sub YourControl_LostFocus()
If Not Me.NewRecord Then
If Me.YourControl.Value <> Me.YourControl.OldValue Then
MsgBox "It's changed!" 'Place code here if data is changed
End If
End If
End Sub[/HTML]
Mar 15 '07 #2

100+
P: 110
oh wow! why didnt i think of that...lol

thanks
Mar 15 '07 #3

missinglinq
Expert 2.5K+
P: 3,532
That's why we're here!
Mar 15 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.