afterupdate, change, and dirty events wont fire in a Textbox

[fritesmodern]

I have a textbox bound to field in a table. The below code won't fire the afterupdate, change, and dirty events for my textbox.

Me.txtMyTextbox= "New Data in My Textbox" // this won't fire the afterupdate, change, and dirty events. What am I missing?

Is there a way to fire any of the aforementioned events by assigning a value directly to a textbox as in the above statement of code?



Thanks in advance

[ItsMe]

Afterupdate and change are events. Some controls have members for these events.

Dirty is a property of a Form. You can check (read) the value of a Form's Dirty property and write to the Dirty property.

If Me.Dirty = true then
me.dirty = False
end if

You can use an event to fire some code. For instance, in the Click event of a button, you can save and commit values in bound controls to the table.

sub MyButton_Click()

if me.dirty then me.dirty = false

end sub

[ssanfu]

AFAIK, events doe not execute when a control is changed by code. You can/could call events to execute code.

The change event is mostly not used because it fires after each keypress. For example, if you wanted to limit what is entered into a textbox control to just even numbers, you could have code that checks to see if the character entered is an even number.

I've only used the Dirty property at the form level to check if something changed on the form.

Example code to call other code:

Private Sub Command0_Click()   'button name
    Me.txtMyTextbox= "New Data in My Textbox"
    Call txtMyTextbox_AfterUpdate
End Sub


Private Sub txtMyTextbox_AfterUpdate()
     Me.txtMyTextbox.BackColor = vbYellow
End Sub

[ItsMe]

AFAIK, events doe not execute when a control is changed by code...

That's the way I understand it.