Hi,
I have a INSERT INTO SQL statement I am using in a master form named Emp_New.
I am trying to save txtEmp_ID and TxtCID data from the subform named Class_Catalog subform into a table named Classes_taken. I get the bracket error. Here is my code:
Private Sub CmdSave_Click()
Dim mySQL As String
mySQL = "INSERT INTO Classes_taken([Emp_ID],[Class_ID])VALUES([forms![Class_Catalog subform]![txtEmp_ID],[forms![Class_Catalog subform]![TxtCID])"
DoCmd.RunSQL mySQL
End Sub
I have a INSERT INTO SQL statement I am using in a master form named Emp_New.
I am trying to save txtEmp_ID and TxtCID data from the subform named Class_Catalog subform into a table named Classes_taken. I get the bracket error. Here is my code:
Private Sub CmdSave_Click()
Dim mySQL As String
mySQL = "INSERT INTO Classes_taken([Emp_ID],[Class_ID])VALUES([forms![Class_Catalog subform]![txtEmp_ID],[forms![Class_Catalog subform]![TxtCID])"
DoCmd.RunSQL mySQL
End Sub