Basic troubleshooting.... (no pun intended).
I open form "AssessorRecords" (remember this - it is important)
I know I have cascading combo boxes (As developer/programmer you should)
I select a value from the first combo box (District) - and get an error
The error is "Enter Parameter Value". Below that it has "Forms!AddAssessor!District"
Looking at the "District" combo box afterupdate event, it has "Me.Team.Requery". I know that this is the second (dependent) combo box of the cascading combo boxes.
I look at the row source for the combo box "Team". Where is the criteria coming from?
Oh, yeah. From the error message and looking at the SQL, I see "Forms!AddAssessor!District".
But wait! What form am I on? It is "AssessorRecords". So the criteria needs to look at the at the primary combo box (District) to get the criteria.
Should "Forms!AddAssessor!District" be referenced or "Forms!AssessorRecords!District" be referenced?
-------------------------------------------------------------------------------------
Why do the two TEAM combo boxes (on different forms) have different row sources?
Form AddAssessor - combo box TEAM row source
Code:
SELECT DISTINCT TblTeam.TeamID, TblTeam.Team
FROM TblTeam
WHERE (((TblTeam.DistrictID)=[forms]![AddAssessor]![District]));
Form AssessorRecords - combo box TEAM row source
Code:
SELECT TblTeam.TeamID, TblTeam.Team, TblTeam.DistrictID
FROM TblDistrict INNER JOIN TblTeam ON TblDistrict.DistrictID = TblTeam.DistrictID
WHERE (((TblTeam.DistrictID)=[forms]![AssessorRecords]![District]));
The combo boxes are doing the same thing, just on different forms..........?????
Does all of the above make sense??
-------------------------------------------------------------------------------------
Also, how did you get it to automatically to open the "AddAssessor" form?
FILE/Options/Current Database/Display Form
-------------------------------------------------------------------------------------
These might help you: (they are a couple of my bookmarked sites I reference)
Problem names and reserved words in Access
http://allenbrowne.com/AppIssueBadWord.html
This might help you: (It is one of my bookmarked sites)
Debugging VBA Code
www.cpearson.com/excel/DebuggingVBA.aspx