Hello Scott:
i have a similar issue in MS Access 2007, and I was hoping you could enlighten me a little.
In a MS Access 2K7 form, I have a button that when clicked on, triggers an INSERT INTO table3 (already created with fields since all 3 tables have differente fields) from a SELECT table1.fields, table2.fields, FROM table1, table2 WHERE these 2 tables have the same field x match text in forms!form1!control.
When button is clicked, an error displays "Missing (
at end of sql statement"; here is "code":
strSQL = "INSERT INTO [tmpDesktop Info] VALUES ([Service Tag], PCPO, PCDate, PCRAM, MSOVer, MSOPO)" _
& "SELECT [Desktop Info].[Service Tag], [Desktop Info].[HW Ship Date], [Desktop Info].[HW PO #], [Department Inventory].[Memory], [Department Inventory].[Current Ver Installed]" _
& "FROM [Department Inventory], [Desktop Info]" _
& "WHERE (([Desktop Info].[Service Tag])= & ' [Forms]![Form1]![PCST] ' & AND [Department Inventory].[PCST] = & ' [Forms]![Form1]![PCST]))' &;"
I've also tried the Insert Into for each Select but still the same error.
Please help!
Thanx,
Egac1967