I have an access form that uses the following query as its basis:
SELECT tblCourses.CourseNumber, tblOrderDetail.Semester, tblOrderDetail.Section, tblOrderDetail.Year, tblCustomer.LastName, tblCustomer.FirstName, tblUniversities.UniversityCode, tblOrderDetail.RegistrationFormRcvd, tblOrderDetail.Grade, tblOrderDetail.GradeDate, tblUniversities.Audit, tblCustomer.CustomerPK, tblCustomer.EmailAddress, tblUniversities.UniversitiesPK, tblUniversities.UniverisityName, tblCourses.CourseTitle FROM tblCourses INNER JOIN ((tblCustomer INNER JOIN tblOrders ON tblCustomer.CustomerPK=tblOrders.CustomerPK) INNER JOIN (tblUniversities INNER JOIN tblOrderDetail ON tblUniversities.UniversitiesPK=tblOrderDetail.UniversitiesPK) ON tblOrders.OrdersPK=tblOrderDetail.OrdersPK) ON tblCourses.CoursePK=tblOrderDetail.CoursePK WHERE (((tblCourses.CourseNumber)=forms!frmGradeEntry!cboCourse) And ((tblOrderDetail.Semester)=forms!frmGradeEntry!cboSemester) And ((tblOrderDetail.Year)=forms!frmGradeEntry!txtYear) And ((tblUniversities.UniversityCode)=forms!frmGradeEntry!cboUniversity) And ((tblOrderDetail.Cancelled)=False)) ORDER BY tblCourses.CourseNumber, tblCustomer.LastName, tblCustomer.FirstName;
yesterday, I was able to edit the records in the 'order detail' based on this form.. today I cannot. I went to last week's version of the database (both front & backend), no changes have taken place except data updates due to normal use, in last weeks version of the database/app, I can update the records from the table, on the production version of the application, I cannot. Any clues?