List box and query update.

yeppy12

Registered User.
Local time
Today, 12:53
Joined
Sep 11, 2007
Messages
38
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.
 
I think you may want to use a listbox's click event...

Regards,
Tim
 

Attachments

Thanks. That works fine.
 
One more question. I want to add a dialog box that asks the user for a school id. Based on what is entered, I want the information associated with that id to fill in on the form (i.e., school address, principal, phone number, etc). How would I go about doing that?
 

Users who are viewing this thread

Back
Top Bottom