Hello, I have a form where I want to update a certain cell from the EMP_TBL. It is saying my syntax is wrong and I can not find the error. If you could point me in the right direction, that would be greatly appreciated.
Dim emp_id As Integer
emp_id = Me.cmb_empl
Dim employed As String
employed = Me.cmb_quest
Dim dbs As Database
Dim qdf As QueryDef
Set dbs = CurrentDb()
dbs.Execute "UPDATE EMP_TBL " _
& "SET EMPLOYED? = employed " _
& "WHERE EMP_ID = emp_id;"
dbs.Close