I am having some problems transferring data from my MS Form to an MS report. I am writing Code for a button Command to grab the information in the text boxs or combo boxes of a form and put the data into its respective place in the form. I use the following code to do so:
Expand|Select|Wrap|Line Numbers
- [Private Sub cmdProduceReport_Click()
- MsgBox "Producing Initial Issue Report"
- Dim strquery As String
- strquery = "INSERT INTO [rptInitialIssue] " & _
- "( [txtEmailSubject])" & _
- "VALUES(" & _
- "" & Me.EmailSubject_Date & "," & _
- ")"
- DoCmd.RunSQL strquery
- MsgBox "Report has been Produced. Opening Report for export."
- End Sub]
Runtime-error '3705'
Syntax error (missing operator) in query expression. Can someone help me with this. Thank you