increase value of field

[didacticone]

i have an unbound text box on a form with '0' entered in it. i also have another text box linked to my table. what i would like to is when the linked text box (dayoff) has a certain criteria entered (ie. Vacation) i would like my unbound text box (vacaused) to increase by 1. any ideas?

[missinglinq]

This will do it:

Private Sub DayOff_AfterUpdate()
 If Me.DayOff = "vacation" Then Me.vacaused = Me.vacaused + 1
End Sub

Linq ;0)>