Changing data in a bound Textbox

[CLOS]

Help! Help! Urgent Help!

I have a bound textbox that I want to test to see if the
user changed any of the data found in the bound textbox.
In otherwords, I want to know if the data has been changed.
Can somebody give me the [event procedure] code for this one, thanks!

 

[jebry]

Hi!

In the BeforeUpdate event procedure for the form you can compare the OldValue and the Value of the textbox.

Private Sub From_BeforeUpdate(Cancel As Integer)

If Me!YourTextBox.OldValue <> Me!YourTextBox.Value Then
Do your stuff here
End If

End Sub

hth
Jeff Bridgham
bridgham@purdue.edu

 

[CLOS]

Jebry,[b/]

Thanks so much for your Help. You are truly super.