I have a field on my form with a control name of Equipment Hours (me.equipmenthours) when a user enters 9990 hours into the hours field that means that the vehicle hours are about to roll back to 0000 (9999 max). I need to add 24 to that value of 9990 that the users enter into the field and store that value for future error checking.
For example:
A user enters 9990 into the equipment hours field.
I need to add 24 to that number to equal 0014 and store that value for error checking in the future. How do I truncate anything over 9999 to be 0 + that number? I want to make the equipment hours field be my current hours and equipment hours + 24 to be the maximum number of hours allowed to enter the next time the hours are checked. I have a problem with the users entering the wrong hours and I don't know how to prevent it. Any other ideas or criticisms will be appreciated.
