A sample MS Access 2000 datebase. The code that I need is for a future project. This sample database has Two combo boxes. One with states and one with cities. I now have it programed that the combo boxes will sort with States in one combo, and all Cites the second combo. I can then offer user the ability to add at run time to the States and the Cities, however all cities show on second combo. Previously I had it program so that the first combo of states open a combo with only the cities for that state, but then I could not offer to user the option of adding cities at run time.
code to filter only cites for that state and still add states and cities at run time
MS Access 2000