After looking at your dB, I would say the table "TblAssessor" structure is incorrect. From form "AssessorRecord", you keep trying to change the "DistrictID" in "TblDistrict". This cannot be done.
The rule is one table, one form. But "QryAssessor" has 3 tables in it.
I would change the table structure for "TblAssessor" by adding field "DistructID" (Long).
I would change "QryAssessor" to
Code:
SELECT TblAssessor.AssessorID, TblAssessor.AssessorName, TblAssessor.JobTitle, TblAssessor.Organisation, TblAssessor.WorkNumber, TblAssessor.EmailAddress, TblAssessor.TeamID_FK, TblAssessor.Address, TblAssessor.IsCurrent, TblAssessor.DistrictID_FK
FROM TblAssessor
WHERE (((TblAssessor.AssessorName)=[Forms]![Homepage]![SearchAssessorName]));
The "District" after update event would be:
Code:
Private Sub District_AfterUpdate()
Me.Team = Empty
Me.Team.Requery
End Sub
Edit:
@#$%#$..... I just realized I used my naming convention for the two fields in "TblAssessor". Just forget the "_FK" after the names.