I get an Syntax error in Join operation. Runtime '3135
'
Red font is what I added to the code. The code was running fine before. I was trying to filter down some more by using another table.Code:sSQLChild ="SELECT Table1.* FROM Table1 INNER JOIN SingleLins ONqryMEQUIPWithChild.[Equip LIN] = SingleLins.[Equip LIN] WHERETable1.parent_equipment_item_id = '" & sUniqueID & "' AND[RowType] = 'MEQUIP' ORDER BY Table1.ID;"Set rstChild =CurrentDb.OpenRecordset(sSQLChild, dbOpenDynaset)