Update one combo with value selected in another

  • Thread starter Thread starter Tina
  • Start date Start date
T

Tina

I've seen this type of question answered before, but not
quite in the way I need...I have two combo boxes on my
form. In the first one, the user selects one of three
counties: A, B, Or C. In, the second one are school
districts in each county. I need for the values of the
second combo box to be restricted based on the value
chosen in the first combo box. For example, if the user
chooses county A, then combo 2 needs to be restricted to
school districts 1, 2, and 3. If the user chooses county
B, then combo 2 needs to be restricted to school
districts 4, 5, and 6. I'm thinking this is pretty
simple, but I've only dabbled in VB, and I can't seem to
figure it out. Can someone give me a nudge in the right
direction? Thanks
 
Back
Top