Runtime error "3135"

[aman]

Hi guys

I am getting Syntex error in Join operation below:

 Set rs = CurrentDb.OpenRecordset("SELECT tblstaff.[Staff Name] AS Agent, tblstaff_1.[Staff Name] AS Auditor, tblTCForm.DateEntered, tblTCForm.Ind_Comments, tblTCForm.Coach_Comments, tblTCForm.QAO_Comments FROM tblstaff INNER JOIN (tblstaff AS tblstaff_1 INNER JOIN tblTCForm ON (tblstaff_1.[Staff Number] = tblTCForm.LineManager) AND (tblstaff.[Staff Number] = tblTCForm.Ind_Name) WHERE (((tblTCForm.ID)=15))))")

ANy help will be much appreciated.

Thanks

 

[CJ_London]

looks like

AND (tblstaff.[Staff Number] = tblTCForm.Ind_Name)

should be

AND (tblstaff_1.[Staff Number] = tblTCForm.Ind_Name)

 

[aman]

And the following gives me syntax error in the expression error message:

 Set rs = CurrentDb.OpenRecordset("SELECT tblstaff.[Staff Name] AS Agent, tblTCForm.LineManager AS Auditor, tblTCForm.DateEntered, tblTCForm.Ind_Comments, tblTCForm.Coach_Comments, tblTCForm.QAO_Comments, tblTCForm.ID FROM tblstaff INNER JOIN tblTCForm ON tblstaff.[Staff Number] = tblTCForm.Ind_Name WHERE (((tblTCForm.ID)=" & txtHidden1 & "))")

 

[Minty]

When you have issues like this construct your sql query statement as a string first, then debug.print it in the immediate window. Copy and paste it into the query designer in SQL view - it will highlight where your problem is.

Once you have it correctly formatted simply use
Set rs = CurrentDb.OpenRecordset sYourSqlString
to open it.