S
Susan L
I have a Project Schedule form based on one table (contains "planned" project
dates for each US state) and a Project Record containing a master (again, for
each US state) and continuous subform, each based on their own tables.
On the Project Record subform (continuous), the user selects a variety of
project activities, some of which under certain condictions have dates that
must be filled in (dtCallDate is the control name). For example, when the
activity "Teleconference Scheduled" is selected, the dtCallDate control
becomes enabled for entering a date. I want the date entered to go into the
Project Schedule table, ActualTeleconDate field.
Both tables have a common field "state", which I know must go into a WHERE
clause or the equivalent. Can anyone suggest the code to use. I'm thinking
that I should put the code in the AfterUpdate event of dtCallDate. Any help
would be appreciated.
dates for each US state) and a Project Record containing a master (again, for
each US state) and continuous subform, each based on their own tables.
On the Project Record subform (continuous), the user selects a variety of
project activities, some of which under certain condictions have dates that
must be filled in (dtCallDate is the control name). For example, when the
activity "Teleconference Scheduled" is selected, the dtCallDate control
becomes enabled for entering a date. I want the date entered to go into the
Project Schedule table, ActualTeleconDate field.
Both tables have a common field "state", which I know must go into a WHERE
clause or the equivalent. Can anyone suggest the code to use. I'm thinking
that I should put the code in the AfterUpdate event of dtCallDate. Any help
would be appreciated.