I am using a text box in the form header on a subform to calculate bal.due. It takes the total due on the main form and subtracts all the payments on the subform. But I don't want the answer to ever show less than zero even if the payments exceed the total due. How can I do this?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Answer not less than zero 1
- Thread starter linda55
- Start date
-
1
- #2
Couldn't you add a function to the OnUpdate of the form that tests the value of the total for less than zero and changes it to zero if true?
Something like:
IF MyForm!Total.Value < 0
MyForm!Total.Value = 0
ENDIF
Planning on earning a little extra pay if the customer over pays??? Just Kidding... Terry M. Hoey
Something like:
IF MyForm!Total.Value < 0
MyForm!Total.Value = 0
ENDIF
Planning on earning a little extra pay if the customer over pays??? Just Kidding... Terry M. Hoey
- Status
Similar threads
- Locked
- Question
