Error in "Insert Into" Query

[WickidWe]

I had already fixed the quotation marks before running but now I get a new Error


this is how the code looks now.

strSQL = "INSERT INTO tblRosterRec ( Date_, FctnID, EmpId, Name ) " & _
"SELECT tbl36hrWeekRosters.Date_, tblFunctions.ReliefCode, qryAllocated.EmpId, qryAllocated.Name " & _
"FROM tbl36hrWeekRosters, qryAllocated INNER JOIN tblFunctions ON qryAllocated.FctnDesc = tblFunctions.FctnDesc " & _
"WHERE tbl36hrWeekRosters.Date_=#" & Me.txtDate & "#;"

it is only stopping at the "dbs.Execute (sSQL)"

[June7]

I really can't see anything wrong with the sql or the procedure. If this doesn't work, want to provide the db for analysis?

CurrentDb.Execute "INSERT INTO tblRosterRec ( Date_, FctnID, EmpId, Name ) " & _
"SELECT tbl36hrWeekRosters.Date_, tblFunctions.ReliefCode, qryAllocated.EmpId, qryAllocated.Name " & _
"FROM tbl36hrWeekRosters, qryAllocated INNER JOIN tblFunctions ON qryAllocated.FctnDesc = tblFunctions.FctnDesc " & _
"WHERE tbl36hrWeekRosters.Date_=#" & Me.txtDate & "#"