I have a main form [frmDistLearnBySubMain] which contains student, assessor and course information, and a linked subform [frmDistLearnContactDets] which contains expanded details of all assessments made by the assessor. (Shown as a continuous form)
The sub form captures amongst others the start and end time of the assessments. I have a field next to it which calculates the duration [txtDuration], and I am then performing a sum of the duration in the form footer [txtDurationTotalCurrentSess].
The main form passes some course information, specifically a value called guided learning hours [txtGLH ]through to the sub form and this is stored in the sub forms header.
What i want is for the user to be able to enter assessment details but not exceed the guided learning hours.
ie, if a course has a GLH of 13 then that value is passed into the sub form where the user is then unable to enter assessments totaling more than 13 hours.
My initial thoughts were that i could validate the end time field with
Expand|Select|Wrap|Line Numbers
- [txtGLH] > [txtDurationTotalCurrentSess]