I have a form with a subform in it. I recently just added a new table in the subform query.
I'm having trouble rearranging the FORM sql into my combobox sql, because now there is a new line in my subform record source (in bold).
My combobox FROM sql is as follows
I tried adding the bolded sql at the last combobox sql but I got an Error:
error 3075:Syntax error(missing operator) in query expression 'qryBelegungPerson
ON (qryBelegungPerson.indFOLand = tblMessauftrag.indFOLand) AND (tblMessauftrag.txtTeilesachnummer = qryBelegungPerson.txtTeilesachnummer) LEFT JOIN qryMessauftragPerson ON tblMessanlage.ID = qryMessauftragPerson.ID '
I am not really good in sql and I am not the one who arranged the code for the combobox.
Thus, I don't know why is the arrangement of the sql of the combobox differs from that in the record source.
Can somebody explain?
I'm having trouble rearranging the FORM sql into my combobox sql, because now there is a new line in my subform record source (in bold).
Code:
FROM (tblMessanlage
RIGHT JOIN (tblMessaufgaben
RIGHT JOIN (tblFOLand
INNER JOIN (tblPrioritaet
RIGHT JOIN (tblPulk
RIGHT JOIN ((tblBauphasen
RIGHT JOIN (qryStammdatenBelegung
INNER JOIN tblMessauftrag
ON (qryStammdatenBelegung.indFOLand = tblMessauftrag.indFOLand)
AND (qryStammdatenBelegung.txtTeilesachnummer = tblMessauftrag.txtTeilesachnummer))
ON tblBauphasen.lngReihenfolge = tblMessauftrag.indBauphase)
INNER JOIN qryBelegungPerson
ON (tblMessauftrag.indFOLand = qryBelegungPerson.indFOLand)
AND (tblMessauftrag.txtTeilesachnummer = qryBelegungPerson.txtTeilesachnummer) )
ON tblPulk.ID = tblMessauftrag.indPulk)
ON tblPrioritaet.ID = tblMessauftrag.indPrioritaet)
ON tblFOLand.ID = tblMessauftrag.indFOLand)
ON tblMessaufgaben.ID = tblMessauftrag.indMessaufgabe)
ON tblMessanlage.ID = tblMessauftrag.indAbweichendeMessanlage)
[B]LEFT JOIN qryMessauftragPerson ON tblMessanlage.ID = qryMessauftragPerson.ID [/B]
My combobox FROM sql is as follows
Code:
FROM (tblPulk
RIGHT JOIN (tblFOLand
INNER JOIN (tblMessanlage
RIGHT JOIN (tblMessaufgaben
RIGHT JOIN (tblPrioritaet
RIGHT JOIN (tblBauphasen
RIGHT JOIN (qryStammdatenBelegung
INNER JOIN tblMessauftrag
ON (qryStammdatenBelegung.indFOLand = tblMessauftrag.indFOLand)
AND (qryStammdatenBelegung.txtTeilesachnummer = tblMessauftrag.txtTeilesachnummer))
ON tblBauphasen.lngReihenfolge = tblMessauftrag.indBauphase)
ON tblPrioritaet.ID = tblMessauftrag.indPrioritaet)
ON tblMessaufgaben.ID = tblMessauftrag.indMessaufgabe)
ON tblMessanlage.ID = tblMessauftrag.indAbweichendeMessanlage)
ON tblFOLand.ID = tblMessauftrag.indFOLand)
ON tblPulk.ID = tblMessauftrag.indPulk)
INNER JOIN qryBelegungPerson
ON (qryBelegungPerson.indFOLand = tblMessauftrag.indFOLand)
AND (tblMessauftrag.txtTeilesachnummer = qryBelegungPerson.txtTeilesachnummer)
I tried adding the bolded sql at the last combobox sql but I got an Error:
error 3075:Syntax error(missing operator) in query expression 'qryBelegungPerson
ON (qryBelegungPerson.indFOLand = tblMessauftrag.indFOLand) AND (tblMessauftrag.txtTeilesachnummer = qryBelegungPerson.txtTeilesachnummer) LEFT JOIN qryMessauftragPerson ON tblMessanlage.ID = qryMessauftragPerson.ID '
I am not really good in sql and I am not the one who arranged the code for the combobox.
Thus, I don't know why is the arrangement of the sql of the combobox differs from that in the record source.
Can somebody explain?