I have three tables: District, City and State (for instance). The first is dependant on the second and the second on the third. I have corresponding forms to enter the codes and descriptions of the entities.
In the Districts form the user first enters the State Code, then the City Code and then the District Code. I am using combo boxes to restrict entry of the codes to valid ones such that only the City Codes within the specified State will appear in the list of valid values etc. The Row Source entry for the combo box City Code reads something like:
SELECT DISTINCTROW (City.CityCode, City.Description from City WHERE
(((City.StateCode)=[Forms]![Districts]!StateCode]));
The problem is once I have selected/entered one valid State Code in a record and I move on the another new record where I enter a new State Code, it always picks up the City Codes for the previous State in the new (and all subsequent records) until I close the form and open it again. How can I make the program “forget” the previous
