Tying Combo Boxes Together 1

[Riskman52]

Greetings to all. I have a form where I have a combo box bound to a table with entries in one specific field called "school". Another field is "department". There are more than one department for each school as noted in each record. Combo Box 1 has the control source as a query on that table which pulls in all the schools. What I am attempting is to have combo box 2 automatically load the corresponding departments when a school is chosen from the drop down box in Combo Box 1, and only the corresponding departments, with a drop down list in combo box 2. Have tried this with some code in combo box 1 as a before update event, but unsuccessful. Not sure of the most effective way to do this, or the code that would be necessary. Any suggestions greatly appreciated.

 

[TheAceMan1]

How are ya Riskman52 . . .

Have a look here faq702-4289

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[PHV]

Search the FAQ area of this forum for cascading or for dependant.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886