increment on exit

[JohnLute]

How can I increment a numeric field to the next number on exiting the field's
control in a subform? I can't find any exmples here and I'm sure it must be
easy!

Thanks for your help!

 

[Linq Adams via AccessMonster.com]

Private Sub YourTextBox_Exit(Cancel As Integer)
If Not IsNull(Me.YourTextBox) Then
Me.YourTextBox = Me.YourTextBox + 1
Else
Me.YourTextBox = 1
End If
End Sub

BTW, Love your Veggie Dip!

 

[JohnLute]

Thanks, Linq!

I wish I could say it was *MY* veggie dip - then maybe I could have
someextra money in the bank!