G
Guest
I created a team nomination form with 3 command buttons, if users click on
any of the button I want the team member information to be inserted into
another table. I used the following code:
Dim SQL As String
Dim strWhere As String
strWhere = Me.Contact_LastName
SQL = "INSERT INTO tblteams " & _
"(teamname) " & _
"SELECT Contact_LastName FROM Results Where =" & strWhere & "'"
DoCmd.RunSQL SQL
But there is an error in the Where clause, can someone help me please?
Thanks
any of the button I want the team member information to be inserted into
another table. I used the following code:
Dim SQL As String
Dim strWhere As String
strWhere = Me.Contact_LastName
SQL = "INSERT INTO tblteams " & _
"(teamname) " & _
"SELECT Contact_LastName FROM Results Where =" & strWhere & "'"
DoCmd.RunSQL SQL
But there is an error in the Where clause, can someone help me please?
Thanks