S
szag via AccessMonster.com
I have a subform that is an allocation (by cost center) of costs by percent.
The user is suppose to put in the percents of different cost centers so they
add up to 100% - I want to be able to send the user a message (and not allow
the record to be saved) unless the percent of all the records add up to 100%.
So if he/she puts in two entries and it adds up to 80% and they try to go to
another record in the main form it won't allow it. Any ideas?
Zag
The user is suppose to put in the percents of different cost centers so they
add up to 100% - I want to be able to send the user a message (and not allow
the record to be saved) unless the percent of all the records add up to 100%.
So if he/she puts in two entries and it adds up to 80% and they try to go to
another record in the main form it won't allow it. Any ideas?
Zag