I created an append query, viewed its SQL code, copied it and pasted into the OnClick event of a form button.
Here is what I pasted:
INSERT INTO Total_List ( [Company#], Company_Name)
SELECT Selected.SlctCompany, Selected.Slct_Company2
FROM Selected;
I keep receiving a syntax error in code? What am I missing? First time trying this so bare with me if stupid question.
Marco
Here is what I pasted:
INSERT INTO Total_List ( [Company#], Company_Name)
SELECT Selected.SlctCompany, Selected.Slct_Company2
FROM Selected;
I keep receiving a syntax error in code? What am I missing? First time trying this so bare with me if stupid question.
Marco