Greetings, all -
I will attempt to explain ... I have a "project database" built and working great, with a main form and two subforms that collect differing data for each project. The subforms are in datasheet view, which allows multiple entries for one table field. (such as status updates, etc)
Ok... now the projects have a defined set of "tasks" that need to be completed. Each task has an expected number of days to complete.
I'd like to develop another form that displays this list of tasks ... and have a date field next to each one that will auto-populate based upon user entry in the first.
Example.... Task 1 completed Today, Task 2 takes 7 days so Task 2 Date auto-pops to 7 days from today, etc etc...
This form will be linked by Project Number to the main form, so each Main form record will have different Task Dates but the same tasks. The only user entry on the Task List is the first date, then the rest should auto-pop (but perhaps have capabiltiy to over-ride?)
Thanks for any assistance.
I will attempt to explain ... I have a "project database" built and working great, with a main form and two subforms that collect differing data for each project. The subforms are in datasheet view, which allows multiple entries for one table field. (such as status updates, etc)
Ok... now the projects have a defined set of "tasks" that need to be completed. Each task has an expected number of days to complete.
I'd like to develop another form that displays this list of tasks ... and have a date field next to each one that will auto-populate based upon user entry in the first.
Example.... Task 1 completed Today, Task 2 takes 7 days so Task 2 Date auto-pops to 7 days from today, etc etc...
This form will be linked by Project Number to the main form, so each Main form record will have different Task Dates but the same tasks. The only user entry on the Task List is the first date, then the rest should auto-pop (but perhaps have capabiltiy to over-ride?)
Thanks for any assistance.
