By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,921 Members | 1,433 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,921 IT Pros & Developers. It's quick & easy.

increase value of field

P: 250
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?
Feb 2 '10 #1
Share this Question
Share on Google+
1 Reply

Expert 2.5K+
P: 3,532
This will do it:
Expand|Select|Wrap|Line Numbers
  1. Private Sub DayOff_AfterUpdate()
  2.  If Me.DayOff = "vacation" Then Me.vacaused = Me.vacaused + 1
  3. End Sub
Linq ;0)>
Feb 2 '10 #2

Post your reply

Sign in to post your reply or Sign up for a free account.