I have a form that has a list box with states as options. I have another list box on the form that has schools as options (I use a query to get the schools). Based on the state chosen, I want the schools listed in the other drop down to appear for that state only.
The name of the table for the states list box is States_All, and the field in that table is States. The table for the other list box is called Schools_All, and the query selects all schools from the Schools field where the type of school is elementary.
I am sure I need to use the AfterUpdate command, but I am not sure how. Any help would be greatly appreciated. Thanks.
The name of the table for the states list box is States_All, and the field in that table is States. The table for the other list box is called Schools_All, and the query selects all schools from the Schools field where the type of school is elementary.
I am sure I need to use the AfterUpdate command, but I am not sure how. Any help would be greatly appreciated. Thanks.