First of all, I just want to say that this forum is awesome. You guys always give the the solution I am looking for.
Basically I am receiving the above error (3144), here is all the code it is highlighting. Any help would be appreciated!!!
Original:
Parsed:Code:DoCmd.RunSQL "UPDATE Tbl_ReviewRecord INNER JOIN Tbl_MasterReviewRecord ON (Tbl_ReviewRecord.Interval = Tbl_MasterReviewRecord.Interval) AND (Tbl_ReviewRecord.Year = Tbl_MasterReviewRecord.Year) AND (Tbl_ReviewRecord.EID = Tbl_MasterReviewRecord.EID) " & _ " SET Tbl_MasterReviewRecord.TL_EID = [Tbl_ReviewRecord]![TL_EID], Tbl_MasterReviewRecord.OM_EID = [Tbl_ReviewRecord]![OM_EID]," & _ " Tbl_MasterReviewRecord.Goal1Chk = [Tbl_ReviewRecord]![Goal1Chk], Tbl_MasterReviewRecord.Goal2Chk = [Tbl_ReviewRecord]![Goal2Chk], Tbl_MasterReviewRecord.Goal3Chk = [Tbl_ReviewRecord]![Goal3Chk], Tbl_MasterReviewRecord.Goal4Chk = [Tbl_ReviewRecord]![Goal4Chk], Tbl_MasterReviewRecord.Goal5Chk = [Tbl_ReviewRecord]![Goal5Chk], Tbl_MasterReviewRecord.Goal6Chk = [Tbl_ReviewRecord]![Goal6Chk], Tbl_MasterReviewRecord.Goal7Chk = [Tbl_ReviewRecord]![Goal7Chk], Tbl_MasterReviewRecord.Goal8Chk = [Tbl_ReviewRecord]![Goal8Chk]," & _ " Tbl_MasterReviewRecord.FocusChk = [Tbl_ReviewRecord]![FocusChk], Tbl_MasterReviewRecord.LeadChk = [Tbl_ReviewRecord]![LeadChk], Tbl_MasterReviewRecord.ResultsChk = [Tbl_ReviewRecord]![ResultsChk], Tbl_MasterReviewRecord.PeopleChk = [Tbl_ReviewRecord]![PeopleChk], Tbl_MasterReviewRecord.ChampChk = [Tbl_ReviewRecord]![ChampChk], Tbl_MasterReviewRecord.FosterChk = [Tbl_ReviewRecord]![FosterChk], Tbl_MasterReviewRecord.GlobalChk = [Tbl_ReviewRecord]![GlobalChk], Tbl_MasterReviewRecord.IntlgtChk = [Tbl_ReviewRecord]![IntlgtChk], Tbl_MasterReviewRecord.ComChk = [Tbl_ReviewRecord]![ComChk], Tbl_MasterReviewRecord.SelfChk = [Tbl_ReviewRecord]![SelfChk], Tbl_MasterReviewRecord.ThinkChk = [Tbl_ReviewRecord]![ThinkChk], Tbl_MasterReviewRecord.TechChk = [Tbl_ReviewRecord]![TechChk]," & _ " Tbl_MasterReviewRecord.Prod_Speed = [Tbl_ReviewRecord]![Prod_Speed], Tbl_MasterReviewRecord.Quality = [Tbl_ReviewRecord]![Quality], Tbl_MasterReviewRecord.Safety = [Tbl_ReviewRecord]![Safety], Tbl_MasterReviewRecord.Innovation = [Tbl_ReviewRecord]![Innovation], Tbl_MasterReviewRecord.Commitment = [Tbl_ReviewRecord]![Commitment], Tbl_MasterReviewRecord.Conduct = [Tbl_ReviewRecord]![Conduct], Tbl_MasterReviewRecord.Attendance = [Tbl_ReviewRecord]![Attendance], Tbl_MasterReviewRecord.Teamwork = [Tbl_ReviewRecord]![Teamwork], Tbl_MasterReviewRecord.9Block = [Tbl_ReviewRecord]![9Block], Tbl_MasterReviewRecord.Dept_Comments = [Tbl_ReviewRecord]![Dept_Comments]," & _ " Tbl_MasterReviewRecord.Above_Comments = [Tbl_ReviewRecord]![Above_Comments], Tbl_MasterReviewRecord.Below_Comments = [Tbl_ReviewRecord]![Below_Comments], Tbl_MasterReviewRecord.Gen_Comments = [Tbl_ReviewRecord]![Gen_Comments], Tbl_MasterReviewRecord.Next_Moves = [Tbl_ReviewRecord]![Next_Moves]," & _ " Tbl_MasterReviewRecord.Next_Moves = [Tbl_ReviewRecord]![Next_Moves], Tbl_MasterReviewRecord.Goal1Text = [Tbl_ReviewRecord]![Goal1Text], Tbl_MasterReviewRecord.Goal2Text = [Tbl_ReviewRecord]![Goal2Text], Tbl_MasterReviewRecord.Goal3Text = [Tbl_ReviewRecord]![Goal3Text], Tbl_MasterReviewRecord.Goal4Text = [Tbl_ReviewRecord]![Goal4Text], Tbl_MasterReviewRecord.Goal5Text = [Tbl_ReviewRecord]![Goal5Text], Tbl_MasterReviewRecord.Goal6Text = [Tbl_ReviewRecord]![Goal6Text], Tbl_MasterReviewRecord.Goal7Text = [Tbl_ReviewRecord]![Goal7Text], Tbl_MasterReviewRecord.Goal8Text = [Tbl_ReviewRecord]![Goal8Text]," & _ " Tbl_MasterReviewRecord.Cell = [Tbl_ReviewRecord]![Cell], Tbl_MasterReviewRecord.JobCd = [Tbl_ReviewRecord]![JobCd], Tbl_MasterReviewRecord.JobDesc = [Tbl_ReviewRecord]![JobDesc], Tbl_MasterReviewRecord.Badge = [Tbl_ReviewRecord]![Badge], Tbl_MasterReviewRecord.Writeup = [Tbl_ReviewRecord]![Writeup]," & _ " Tbl_MasterReviewRecord.FocusG = [Tbl_ReviewRecord]![FocusG], Tbl_MasterReviewRecord.LeadG = [Tbl_ReviewRecord]![LeadG], Tbl_MasterReviewRecord.ResultsG = [Tbl_ReviewRecord]![ResultsG], Tbl_MasterReviewRecord.PeopleG = [Tbl_ReviewRecord]![PeopleG], Tbl_MasterReviewRecord.ChampG = [Tbl_ReviewRecord]![ChampG], Tbl_MasterReviewRecord.FosterG = [Tbl_ReviewRecord]![FosterG], Tbl_MasterReviewRecord.GlobalG = [Tbl_ReviewRecord]![GlobalG], Tbl_MasterReviewRecord.IntlgtG = [Tbl_ReviewRecord]![IntlgtG], Tbl_MasterReviewRecord.ComG = [Tbl_ReviewRecord]![ComG], Tbl_MasterReviewRecord.SelfG = [Tbl_ReviewRecord]![SelfG], Tbl_MasterReviewRecord.ThinkG = [Tbl_ReviewRecord]![ThinkG], Tbl_MasterReviewRecord.TechG = [Tbl_ReviewRecord]![TechG], Tbl_MasterReviewRecord.MRR = [Tbl_ReviewRecord]![MRR]," & _ " WHERE (((Tbl_ReviewRecord.Year)=[Forms]![Frm_Admin]![cmboBxYear]) AND ((Tbl_ReviewRecord.Interval)=[Forms]![Frm_Admin]![CmboBxInterval]) AND ((Tbl_ReviewRecord.TL_EID)=DLookUp('[TL_EID]','Tbl_TL','[TL] = ''' & [Forms]![frm_Admin]![CmboBxTL] & '''')));"
First of all, I just want to say that this forum is awesome. You guys always give the the solution I am looking for.
Basically I am receiving the above error (3144), here is all the code it is highlighting. Any help would be appreciated!!!
Code:DoCmd.RunSQL "UPDATE Tbl_ReviewRecord INNER JOIN Tbl_MasterReviewRecord ON (Tbl_ReviewRecord.Interval = Tbl_MasterReviewRecord.Interval) AND (Tbl_ReviewRecord.Year = Tbl_MasterReviewRecord.Year) AND (Tbl_ReviewRecord.EID = Tbl_MasterReviewRecord.EID) " & _ " SET Tbl_MasterReviewRecord.TL_EID = [Tbl_ReviewRecord]![TL_EID], Tbl_MasterReviewRecord.OM_EID = [Tbl_ReviewRecord]![OM_EID]," & _ " Tbl_MasterReviewRecord.Goal1Chk = [Tbl_ReviewRecord]![Goal1Chk], Tbl_MasterReviewRecord.Goal2Chk = [Tbl_ReviewRecord]![Goal2Chk], Tbl_MasterReviewRecord.Goal3Chk = [Tbl_ReviewRecord]![Goal3Chk], Tbl_MasterReviewRecord.Goal4Chk = [Tbl_ReviewRecord]![Goal4Chk], Tbl_MasterReviewRecord.Goal5Chk = [Tbl_ReviewRecord]![Goal5Chk], Tbl_MasterReviewRecord.Goal6Chk = [Tbl_ReviewRecord]![Goal6Chk], Tbl_MasterReviewRecord.Goal7Chk = [Tbl_ReviewRecord]![Goal7Chk], Tbl_MasterReviewRecord.Goal8Chk = [Tbl_ReviewRecord]![Goal8Chk]," & _ " Tbl_MasterReviewRecord.FocusChk = [Tbl_ReviewRecord]![FocusChk], Tbl_MasterReviewRecord.LeadChk = [Tbl_ReviewRecord]![LeadChk], Tbl_MasterReviewRecord.ResultsChk = [Tbl_ReviewRecord]![ResultsChk], Tbl_MasterReviewRecord.PeopleChk = [Tbl_ReviewRecord]![PeopleChk], Tbl_MasterReviewRecord.ChampChk = [Tbl_ReviewRecord]![ChampChk], Tbl_MasterReviewRecord.FosterChk = [Tbl_ReviewRecord]![FosterChk], Tbl_MasterReviewRecord.GlobalChk = [Tbl_ReviewRecord]![GlobalChk], Tbl_MasterReviewRecord.IntlgtChk = [Tbl_ReviewRecord]![IntlgtChk], Tbl_MasterReviewRecord.ComChk = [Tbl_ReviewRecord]![ComChk], Tbl_MasterReviewRecord.SelfChk = [Tbl_ReviewRecord]![SelfChk], Tbl_MasterReviewRecord.ThinkChk = [Tbl_ReviewRecord]![ThinkChk], Tbl_MasterReviewRecord.TechChk = [Tbl_ReviewRecord]![TechChk]," & _ " Tbl_MasterReviewRecord.Prod_Speed = [Tbl_ReviewRecord]![Prod_Speed], Tbl_MasterReviewRecord.Quality = [Tbl_ReviewRecord]![Quality], Tbl_MasterReviewRecord.Safety = [Tbl_ReviewRecord]![Safety], Tbl_MasterReviewRecord.Innovation = [Tbl_ReviewRecord]![Innovation], Tbl_MasterReviewRecord.Commitment = [Tbl_ReviewRecord]![Commitment], Tbl_MasterReviewRecord.Conduct = [Tbl_ReviewRecord]![Conduct], Tbl_MasterReviewRecord.Attendance = [Tbl_ReviewRecord]![Attendance], Tbl_MasterReviewRecord.Teamwork = [Tbl_ReviewRecord]![Teamwork], Tbl_MasterReviewRecord.9Block = [Tbl_ReviewRecord]![9Block], Tbl_MasterReviewRecord.Dept_Comments = [Tbl_ReviewRecord]![Dept_Comments]," & _ " Tbl_MasterReviewRecord.Above_Comments = [Tbl_ReviewRecord]![Above_Comments], Tbl_MasterReviewRecord.Below_Comments = [Tbl_ReviewRecord]![Below_Comments], Tbl_MasterReviewRecord.Gen_Comments = [Tbl_ReviewRecord]![Gen_Comments], Tbl_MasterReviewRecord.Next_Moves = [Tbl_ReviewRecord]![Next_Moves]," & _ " Tbl_MasterReviewRecord.Next_Moves = [Tbl_ReviewRecord]![Next_Moves], Tbl_MasterReviewRecord.Goal1Text = [Tbl_ReviewRecord]![Goal1Text], Tbl_MasterReviewRecord.Goal2Text = [Tbl_ReviewRecord]![Goal2Text], Tbl_MasterReviewRecord.Goal3Text = [Tbl_ReviewRecord]![Goal3Text], Tbl_MasterReviewRecord.Goal4Text = [Tbl_ReviewRecord]![Goal4Text], Tbl_MasterReviewRecord.Goal5Text = [Tbl_ReviewRecord]![Goal5Text], Tbl_MasterReviewRecord.Goal6Text = [Tbl_ReviewRecord]![Goal6Text], Tbl_MasterReviewRecord.Goal7Text = [Tbl_ReviewRecord]![Goal7Text], Tbl_MasterReviewRecord.Goal8Text = [Tbl_ReviewRecord]![Goal8Text]," & _ " Tbl_MasterReviewRecord.Cell = [Tbl_ReviewRecord]![Cell], Tbl_MasterReviewRecord.JobCd = [Tbl_ReviewRecord]![JobCd], Tbl_MasterReviewRecord.JobDesc = [Tbl_ReviewRecord]![JobDesc], Tbl_MasterReviewRecord.Badge = [Tbl_ReviewRecord]![Badge], Tbl_MasterReviewRecord.Writeup = [Tbl_ReviewRecord]![Writeup]," & _ " Tbl_MasterReviewRecord.FocusG = [Tbl_ReviewRecord]![FocusG], Tbl_MasterReviewRecord.LeadG = [Tbl_ReviewRecord]![LeadG], Tbl_MasterReviewRecord.ResultsG = [Tbl_ReviewRecord]![ResultsG], Tbl_MasterReviewRecord.PeopleG = [Tbl_ReviewRecord]![PeopleG], Tbl_MasterReviewRecord.ChampG = [Tbl_ReviewRecord]![ChampG], Tbl_MasterReviewRecord.FosterG = [Tbl_ReviewRecord]![FosterG], Tbl_MasterReviewRecord.GlobalG = [Tbl_ReviewRecord]![GlobalG], Tbl_MasterReviewRecord.IntlgtG = [Tbl_ReviewRecord]![IntlgtG], Tbl_MasterReviewRecord.ComG = [Tbl_ReviewRecord]![ComG], Tbl_MasterReviewRecord.SelfG = [Tbl_ReviewRecord]![SelfG], Tbl_MasterReviewRecord.ThinkG = [Tbl_ReviewRecord]![ThinkG], Tbl_MasterReviewRecord.TechG = [Tbl_ReviewRecord]![TechG], Tbl_MasterReviewRecord.MRR = [Tbl_ReviewRecord]![MRR]," & _ " WHERE (((Tbl_ReviewRecord.Year)=[Forms]![Frm_Admin]![cmboBxYear]) AND ((Tbl_ReviewRecord.Interval)=[Forms]![Frm_Admin]![CmboBxInterval]) AND ((Tbl_ReviewRecord.TL_EID)=DLookUp('[TL_EID]','Tbl_TL','[TL] = ''' & [Forms]![frm_Admin]![CmboBxTL] & '''')));"