increment on exit

  • Thread starter Thread starter JohnLute
  • Start date Start date
J

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!
 
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!
 
Thanks, Linq!

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