I have a main form that lists the CLASS that is being held and the subform lists the topics/training modules that will be discussed. In the subform I want to be able to type in a number in the "Length" field (such as 1, for 1 hour) and then have it automatically calculate the start time and the end time of that module. The challenge is that this will change for each new record in the subform.
Example:
Length = 1, then Start = 8:00 AM and End = 9:00 AM, but for the second row, if I type in 1, the start should read 9:00 AM and End 10:00 AM.
Questions:
1. What is the best way to establish the start of the class (a separate field for "ClassStart"?
2. How can I get each successive row to start at the finish time of the previous row (as in the example above - if row 1 starts at 8AM and is 1 hour in lenght, then row 2 should start at 9AM)?
Thanks in advance
Example:
Length = 1, then Start = 8:00 AM and End = 9:00 AM, but for the second row, if I type in 1, the start should read 9:00 AM and End 10:00 AM.
Questions:
1. What is the best way to establish the start of the class (a separate field for "ClassStart"?
2. How can I get each successive row to start at the finish time of the previous row (as in the example above - if row 1 starts at 8AM and is 1 hour in lenght, then row 2 should start at 9AM)?
Thanks in advance
