I was actually able to get it to work using the following code:
Code:
CurrentDb.Execute "Update tblEmployeeFiles set SurrogateTeam = '" & Forms!frmLogin!cboUser.Column(0) & "' Where EmployeeID = " & Me!SurrogateSelect.Column(3), dbFailOnError
What I am trying to do now is, I have a list box on the form which shows who is currently a surrogate and I want it where if you click on the name in the list box it changes THAT persons SurrogateTeam back to match their EmployeeID. I thought reverse engineering it would be easy but I can't figure this one out. The list box is named SurrogateNames and contains FirstName, LastName, EmployeeID, and SurrogateTeam.