queries, editing a specific field

[Khalil Handal]

Hi all,
I have a complicated query with the following SQL

SELECT [FirstName] & " " & [FathersName] & " " & [GrandFatherName] & " " & [FamilyName] AS NameOfStudent, tblSchoolYears.SchoolYear, tlkpGrades.GradeLevel, tblGradeSection.GradeSection, tblStudents.PlaceOfBirth, tblStudents.BirthDate, tblStudents.IdentitiyCardNumber, tblDistricts.City, tblJoinStudentsYears.CurrentStudent
FROM tlkpGrades RIGHT JOIN ((tblGradeSection RIGHT JOIN (tblStudents LEFT JOIN (tblSchoolYears RIGHT JOIN tblJoinStudentsYears ON tblSchoolYears.pkSchoolYears = tblJoinStudentsYears.fkSchoolYears) ON tblStudents.pkIdNumber = tblJoinStudentsYears.fkStudentGrade) ON tblGradeSection.pkGradeSection = tblJoinStudentsYears.fkGradeSection) LEFT JOIN (tblDistricts RIGHT JOIN tblStudentAddresses ON tblDistricts.pkDistrictId = tblStudentAddresses.fkDistrictID) ON tblStudents.pkIdNumber = tblStudentAddresses.fkIDNumber) ON tlkpGrades.pkGrades = tblJoinStudentsYears.fkGrades
WHERE (((tblSchoolYears.SchoolYear) Like [Forms]![frmStudentsLists]![cboSchoolYear]) AND ((tlkpGrades.GradeLevel) Like [Forms]![frmStudentsLists]![cboGradeLevel]) AND ((tblGradeSection.GradeSection) Like [Forms]![frmStudentsLists]![cboGradeSection]) AND ((tblJoinStudentsYears.CurrentStudent)=True))
ORDER BY [FirstName] & " " & [FathersName] & " " & [GrandFatherName] & " " & [FamilyName];

Is it possible to edit CurrentStudent field?

Sincerely yours
Khalil

[ranman256]

depends on the query, due to some joins it wont allow you to edit fields.
you may have to use a single table query (to edit) but filter using other fields.

[Khalil Handal]

Hi,
Thank you.

I created a another query and it worked fine.