I'm working in Access 2003 trying to build something that will allow users to identify employees' processes within their groups.
I have a continuous form that shows the processes for each team. Beside each process I have a combo box for the user to select the employee name associated with the process.
The form is based on the process table, but I want to update the
values in employee info table.
I know that this code does not work, but I was hoping it would explain what I am trying to do and perhaps someone could point me in the right direction.....
I have a continuous form that shows the processes for each team. Beside each process I have a combo box for the user to select the employee name associated with the process.
The form is based on the process table, but I want to update the
values in employee info table.
Code:
Do While Not .EOF
With Forms!subfrmZoneOrg1.txtEMPNumber strQuery = "UPDATE EMPInfo " & _
"SET ProcessID= " & Forms!subformZoneOrg1.ProcessID & _
" WHERE EMPNumber = " & .Column(0, varItem)
CurrentDb.Execute strQuery, dbFailOnError
End With
Loop