Two Tables Setup - Transfer A Record Between Two

I have two tables set up and am trying to transfer a record between two. I understand that the best method is to maintain one table and use fields to make the record appear in either based on the field but at the moment need to maintain the two until I have more time to merge etc.

I am receiving the following error:
Syntax error (missing operator) in query expression 'Cardsmaintainedbyfacilities.33CAccessCard'.

Code:
Private Sub Command151_Click()On Error GoTo Err_Handler
Dim strSQL As String
strSQL = "INSERT INTO ExitingStaffData (ExitingStaffID, ExitingStaff , SupervisorDetails , ExecAccessCard , IDAccessCard , 33CAccessCard )"
strSQL = strSQL + " SELECT Cardsmaintainedbyfacilities.id, Cardsmaintainedbyfacilities.ExitingStaff ,

[Code] ....

Works fine for all other lines (especially when I delete the line from the code). Just gets stuck on that line. I have checked both tables and the table and all associated data match - its a yes/no data type (same as Execaccesscard and IDCard). Just that one line crashes.