I need to have a field in a continuous form use a value from the previous row.
Using the "Order" field and the first Start Date I need the rest of the "Start" fields to fill in.
The first "Start" and "End" fields are calculations in the underlying query.
The remaining starts field values (in order) would use "End" + 1
Order Start End
1 2/17/14 2/22/14
I have attached an example db. The Project Form has a subform on it that shows tasks. That is where I need the help.