error in VBA code

[Programming]

the following code gives me error of missing operator.
can anybody help

Me.RecordSource = "SELECT tblEmploymentEngagementEvaluation.EEVID, " _
& "tblEmploymentEngagementEvaluation.EmployerID , " _
& "tblEmployer.EmployerID , tblEmployer.OrganizationNameEnglish, " _
& "tblContacts.ContactID , tblContacts.FullName, tblSemester.SemesterID," _
& "tblSemester.SemesterName , tblEmploymentEngagementEvaluation.SemesterID," _
& "tblEmploymentEngagementEvaluation.SupervisorID , tblEmploymentEngagementEvaluation.OverAllEvaluation," _
& "tblEmploymentEngagementEvaluation.EvaluationDate , tblEmploymentEngagementEvaluation.Coordinatorcontact," _
& "tblEmploymentEngagementEvaluation.CoordinatorHelp , tblEmploymentEngagementEvaluation.CoordinatorVisitStudents," _
& "tblEmploymentEngagementEvaluation.StudentsPrepared , tblEmploymentEngagementEvaluation.Experience," _
& "tblEmploymentEngagementEvaluation.AdditionalComments" _
& "FROM tblEmployer INNER JOIN (tblSemester INNER JOIN (tblContacts INNER JOIN tblEmploymentEngagementEvaluation ON tblContacts.ContactID = tblEmploymentEngagementEvaluation.SupervisorID) ON tblSemester.SemesterID = tblEmploymentEngagementEvaluation.SemesterID) ON (tblEmploymentEngagementEvaluation.EmployerID = tblEmployer.EmployerID) AND (tblEmployer.EmployerID = tblContacts.EmployerID) WHERE tblEmploymentEngagementEvaluation.EEVID= " & Me.OpenArgs

 

[pbaldy]

In the interest of learning how to fish, I'd suggest using a variable and using this to see what the finished SQL looks like. If you don't spot the problem, post it here.

http://www.baldyweb.com/ImmediateWindow.htm

 

[June7]

Need a space in front of FROM:

" FROM …

I will assume those spaces breaking up the field names are just typos in the post or thrown in by the forum.

 

[isladogs]

The SQL assumes OpenArgs is a NUMBER
If its a text string you need text delimiters:

WHERE tblEmploymentEngagementEvaluation.EEVID = '" & Me.OpenArgs & "'"

If your field names really do contain spaces then you need to enclose them in [].

In future please enclose your SQL in code tags as I did above using the # button on the reply window toolbar.
This makes it easier to read & avoids the extra spaces added by the forum software after every 50 characters