Private Sub cmdJLAddJob_Click()
'when we click on button Add there are two options
'1 for insert and 2 to update
If Me.txtJLID.Tag & "" = "" Then
'this is insert new
'Add data
CurrentDb.Execute "INSERT INTO joblog_list(Job ID, Company Name, Company Rep Day, Company Rep Night, Well Name, Job Date) " & _
" VALUES(" & Me.txtJLID & ",'" & Me.cboCoJLName & "','" & Me.cboJLCoRepDay & "','" & _
Me.cboJLCoRepNight & "','" & Me.cboJLJobDate & "')"
Me.txtJLID is giving the error
Any suggestions