I have a simple subform within a form for project planning. The subform
contains resources related to the project details in the main form.
What I'd like to do is this:
There is an Start Date field in the main form where people type in the
project start date. Once they type in the start date I would like the
Year
column of the first record in the subform to be loaded with the year of
that
date. The form is in data sheet view, and if the project spanned 2 years
they could press enter to enter in the resources for the second year.
Upon
pressing enter I'd like to have the 'Year' column populated with the
subsequent year, so Year(Start_date)+1. This is done this way so if the
start date changes to another year, the resource years automatically
change
years as well.
Any guidance is appreciated.
