Time: How to increment time in form

[dek]

Hi,



Thanks for viewing this post.

I have a subform called 'Time' that captures alot of time activity by day.

Two of my fields are 'StartTime' and 'EndTime'

I would like to increment the 'StartTime' for a new record (when focused on new record) by using the last record's 'EndTime'. Furthermore, I would like to set the 'EndTime' automatically by 15 mins.

Example

Subform Record 1     - 'StartTime' = 06:00, 'EndTime' = 12:00
Subform New Record - 'StartTime' = [12:00]*, 'EndTime' = 12:15

* As you can see, the new subform record's 'StartTime' is set by the previous records 'EndTime' and is incremented by 15 mins.

Thanks

[June7]

Same suggestion as in your other thread https://www.accessforums.net/forms/subform-copy-selected-fields-current-row-new-row-13372.html

Set global variables then in the code use DateAdd function to increment the variable.