Combo Box Requirement

  • Thread starter Thread starter DaveB
  • Start date Start date
D

DaveB

I have one drop box for: Department

"Department" drop box choses: Surgery
Medicine

I have another drop box for: Divisions

drop box choses: Geriatrics
Endocrinology
General Internal Medicine
Plastic Surgery
Oncology
QUESTION: When I choose the "Department" Medicine, I would
like only certain Divisions to be allowed to be choosen.
Thanks in advance. DaveB
 
This is really just a matter of synchronizing combo boxes - basically that's
a fancy way of saying that you make the rowsource of the second combo
dependant on the value of the first combo.Here's a KB article that describes
how to synchronize two combos - post back if you need more help or further
explanation.

ACC: How to Synchronize Two Combo Boxes on a Form (97624)
http://support.microsoft.com/default.aspx?scid=kb;[LN];97624
 
In the afterupdate event of combobox 1 you need to set the rowsource
property for combobox 2

eg combo2.rowsource = "SELECT field2 FROM table1 where field1 =
combo1.value"

HTH

Al
 
Back
Top