I am a novice attempting to appendl a table in access based on values in an open form. I created a simple table with three fields and a supporting form. I also created a target table that has the same field names: firstname, lastname and city. I created a button on a form that shows data from the source table and used the following code in an 'onclick' event procedure:
Private Sub Detail_Click()
Dim strSql As String
strSql = "INSERT INTO Customers([firstname],[lastname],[city]) " SELECT ("'& Forms![Append_Form]![firstname] &'", "'& Forms![Append_Form]![lastname] & '", "' & Forms![Append_Form]![city] & '");"
This consistantly fails syntax with entire srtSql line highlighted. Any help would be greatly appreciated.