Hi
Please can anybody help I need to
HoursAllowed = 30
Hours for Job: When this field is updated I need all of the rows for that job to sum and if > than [hoursallowed]
raise a validation error and rollback to prevous value.
What is the best method, I have messed about with a calculated txt box but it does not refresh quick enough to run the validation in the macro condition.
Any suggestions would be appericated.
Thanks
Please can anybody help I need to
HoursAllowed = 30
Hours for Job: When this field is updated I need all of the rows for that job to sum and if > than [hoursallowed]
raise a validation error and rollback to prevous value.
What is the best method, I have messed about with a calculated txt box but it does not refresh quick enough to run the validation in the macro condition.
Any suggestions would be appericated.
Thanks
