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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

increment on add new record 3
incrementing record number 5
Incremental number 2
Auto Increment Number 6
Subform Increment Number 1
Incremental search with numbers 7
incremental number 5
Numeric increment 4

Back
Top