When I click on a record on the subform and right click to get the delete record option nothing happens in FORM view but works in DESIGN view.
I have checked all the record and form options and they are all correct.
Using Access 2010
ERROR MESSAGE
The field cannot be updated because another user or process has locked the corresponding record or table. (Error 3164)
Public Sub CopyTasks()
On Error GoTo Err_CopyTasks
Set TaskDB = CurrentDb
Set TaskDB2 = CurrentDb
strSQL = "SELECT * FROM qryTasks WHERE [ActYear] = " & PYear...