C
Chris Nebinger
Well, I could come up with several...
When you update the form fields, also set the TAG property.
For example:
Me.txtID = 32
Me.txtID.Tag=32
Now, you can loop through the controls and check the tag
property versus the value.
dim ctl as Control
for each ctl in me.controls
'Add some kind of error handling or IF for controltype.
'I'll leave that to the user
if ctl.tag <> ctl.value then
msgbox ctl.name & " has been changed."
end if
next
data. Is there a way to do this w/o using the on change
event of each unbound field
When you update the form fields, also set the TAG property.
For example:
Me.txtID = 32
Me.txtID.Tag=32
Now, you can loop through the controls and check the tag
property versus the value.
dim ctl as Control
for each ctl in me.controls
'Add some kind of error handling or IF for controltype.
'I'll leave that to the user
if ctl.tag <> ctl.value then
msgbox ctl.name & " has been changed."
end if
next
populate. I want to be able to test for any change to
data. Is there a way to do this w/o using the on change
event of each unbound field