Any assistance would really be greatly appreciated. I’m a Newbie and have been trying to figure this out all week!!
I have a form called [frmCreateTask] that I am using to add tasks to my table [tblTask].
On this form I have a combo-box [cboEmployee]. I would like my row source to pull employee names from [tblEmployee].
Now where I am having difficulty:
When I select a name from this combo-box, I would like access to store the [EmployeeID] under table “tblTaskAssign”
(either updating an existing record or creating a new record in this table based on the following parameters):
Update [EmployeeID] in [tblTaskAssign] for the record using my forms current [TaskID] and with a [TaskDutyID] = “TaskLead”
If there is not a record with my forms current [TaskID] and with a [TaskDutyID] = “TaskLead” then I would like access to create a new record.
I have attached my db.
Thanks,
Dave
I have a form called [frmCreateTask] that I am using to add tasks to my table [tblTask].
On this form I have a combo-box [cboEmployee]. I would like my row source to pull employee names from [tblEmployee].
Now where I am having difficulty:
When I select a name from this combo-box, I would like access to store the [EmployeeID] under table “tblTaskAssign”
(either updating an existing record or creating a new record in this table based on the following parameters):
Update [EmployeeID] in [tblTaskAssign] for the record using my forms current [TaskID] and with a [TaskDutyID] = “TaskLead”
If there is not a record with my forms current [TaskID] and with a [TaskDutyID] = “TaskLead” then I would like access to create a new record.
I have attached my db.
Thanks,
Dave
