Subform : Increment time in new records [from last record]

[dekk]

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.

[ADezii]

Set the Default Value of the [StartTime] Field in the Sub-Form to

=DateAdd("n",15,DLast("[EndTime]","tblTimes")), 

adjusting for Table Name.