G
Guest
The user enters data in a form (an issue log) and clicks OK. The data should
be appended to Tables!tblComments, but I get an error: "Run-time error
'3075': Syntax error (missing operator) in query expression 'Enter comments
here.'.
Any help would be appreciated.
Note: The form is unbound. The comment field is a memo field.
The code:
Private Sub cmdACOK_Click()
Dim strSQLAddComment As String
strSQLAddComment = "INSERT INTO tblComments ( IssueID, UserID, CommentTime,
Comment, IsResolved )" & _
"SELECT " & Me.txtACIssueID.Value & ", " & Me.txtACUserID.Value & ", #"
& Me.txtACCommentTime.Value & "#, " & Me.txtACComment.Value & ", " &
Me.chkACIsResolved.Value & ";"
DoCmd.RunSQL strSQLAddComment
End Sub
be appended to Tables!tblComments, but I get an error: "Run-time error
'3075': Syntax error (missing operator) in query expression 'Enter comments
here.'.
Any help would be appreciated.
Note: The form is unbound. The comment field is a memo field.
The code:
Private Sub cmdACOK_Click()
Dim strSQLAddComment As String
strSQLAddComment = "INSERT INTO tblComments ( IssueID, UserID, CommentTime,
Comment, IsResolved )" & _
"SELECT " & Me.txtACIssueID.Value & ", " & Me.txtACUserID.Value & ", #"
& Me.txtACCommentTime.Value & "#, " & Me.txtACComment.Value & ", " &
Me.chkACIsResolved.Value & ";"
DoCmd.RunSQL strSQLAddComment
End Sub