I have a continuous form where I have multiple fields to update or create new records.
The afterUpdate event works when I modify the "txtNo" field, but when I create a new record and add value to "txtNo" the afterUpdate event doesn't work.
Which even works for both, update a record or add a new record?
Private Sub txtNo_AfterUpdate()
If Not IsNull(Me.txtNo) And Not IsNull(Me.txtDirection) Then
Me.txtCleForm = Me.txtNo & "-" & Me.txtDirectionID
Me.txtCleFormS = Me.txtNo & "-" & Me.txtDirectionLien