jharding08
Member
- Local time
- Today, 04:46
- Joined
- Feb 16, 2021
- Messages
- 55
I have a field in a subform that I need to have as a calculated field but also stored in the database.
I have a table with Start Date, End Date and Duration
In the sub form(s) I would need the duration to be a calculation of WorkDays(startdate, enddate) and the next subform (With same fields) should default Start date of subform 2 to the end date of subform 1.
I would need all this calculated when the field has changed or on new. Should I put the calculation in the After_update of the involved fields? and just have the Control Source link to the table field?
I have a table with Start Date, End Date and Duration
In the sub form(s) I would need the duration to be a calculation of WorkDays(startdate, enddate) and the next subform (With same fields) should default Start date of subform 2 to the end date of subform 1.
I would need all this calculated when the field has changed or on new. Should I put the calculation in the After_update of the involved fields? and just have the Control Source link to the table field?