I want to apologize for my ignorance because I am new to this type of statement. But when I use:
Private Sub cmdsubmit_Click()
DoCmd.RunSQL "INSERT INTO tblmain (Trainer, Date, Week, A1_1, Comments1, A2_1, Comments2, A3_1, Comments3) Values (forms!frmmain2!cbotrainer, forms!frmmain2!date, forms!frm main2!cboweek, forms!frmmain2!cboans1, forms!frmmain2!Comments1, forms!frmmain2!cboans2, forms!frmmain2!Comments2, forms!frmmain2!cboans3, forms!frmmain2!Comments3);"
End Sub
I get a "Syntax Error in Insert INTO Statement".
I have this statement under a command button with no other code. Just wondering if anyone can see any problems with this code or do I have to put more code under the button.
Note: I use Access 2000
Thanks
________
honda cbr1100xx
Private Sub cmdsubmit_Click()
DoCmd.RunSQL "INSERT INTO tblmain (Trainer, Date, Week, A1_1, Comments1, A2_1, Comments2, A3_1, Comments3) Values (forms!frmmain2!cbotrainer, forms!frmmain2!date, forms!frm main2!cboweek, forms!frmmain2!cboans1, forms!frmmain2!Comments1, forms!frmmain2!cboans2, forms!frmmain2!Comments2, forms!frmmain2!cboans3, forms!frmmain2!Comments3);"
End Sub
I get a "Syntax Error in Insert INTO Statement".
I have this statement under a command button with no other code. Just wondering if anyone can see any problems with this code or do I have to put more code under the button.
Note: I use Access 2000
Thanks
________
honda cbr1100xx
Last edited: