Great thank you - that's one thing off my list.
The next problem: when trying to add an assessor (or edit their details) I have the option to select district and team - teams are restricted to one district, with many teams in each district (similar to States/Counties in Countries). I want to limit the teams available to only their district and I have found one method of doing this - https://msdn.microsoft.com/en-us/lib.../ff196029.aspx, however if a district is accidentally selected/needs to be changed due to the assessor changing teams I have a problem since the old teams still apply (see images below)
The SQL code I use for the 'team' row source is: SELECT distinct TeamDetails.Team, TeamDetails.TeamID FROM TeamDetails WHERE (((TeamDetails.District)=[forms]![Assessor Records Form]![District])) UNION select distinct null, null FROM TeamDetails ORDER BY TeamDetails.Team;
while the row source for 'District' is a query which pulls in the district's from the district table.
with the districts listed in the DistrictDetails table, while the Teams and districts they fall under are listed in the TeamDetails table.
Have you got a way of getting around my problem? I don't mind trying a different method or just fixing this one, whichever you find easiest. Again, if you need any more information, just let me know.