Two updates with Unlocked Control and AfterUpdate

[Pato-chan]

I have a bound textbox control (txtNotes) that is unlocked to allow for
edits. But I want to update the behind-the-scenes table using the
AfterUpdate Event of the textbox instead of Access' automated update
protocol. Reason being, I need to run an Update or Append query depending on
certain criteria. How might I turn off the Access protocol to update the
record if I'm going to do it in the AfterUpdate Event?

 

[Klatuu]

You really can't; however, even if you update the record programmatically,
you would need to requery the form before you can do you update/append. That
is because even though the record is updated in the form, it has not been
updated in the table. If you want to update the record yourself, you can:

If Me.Dirty Then
Me.Dirty = False 'Updates form recordset
Me.Requery 'Updates the table
End If