G
Guest
I have a database tracking tasks in our office - tblTasks. I am using a cbo
to populate the Field: Allocated Person on tblTasks, with the named person
responsible for the task. tblAllocated is linked to tblTasks via TasksID.
When I enter new data into Allocated Person field (via cbo), a message box
asks whether I wish to add new entry, as expected. When I click yes, I get
'Run-time Error 3201. Cannot add new or change a record because a related
record is required in tblTask'. Also, I know the AllocationID should be saved
into tblTask, but no data is being copied into the main table (tblTask)
I hope this makes sense and thanks for any help
steven
to populate the Field: Allocated Person on tblTasks, with the named person
responsible for the task. tblAllocated is linked to tblTasks via TasksID.
When I enter new data into Allocated Person field (via cbo), a message box
asks whether I wish to add new entry, as expected. When I click yes, I get
'Run-time Error 3201. Cannot add new or change a record because a related
record is required in tblTask'. Also, I know the AllocationID should be saved
into tblTask, but no data is being copied into the main table (tblTask)
I hope this makes sense and thanks for any help
steven