how to refresh combo boxes dependant upon the choice in another

T

tecas

I have a form where the user will pick a department and that choice
should determine other combo box lists elsewhere on the form and
subforms. How do I update the other combo boxes' lists whenever the
department combo box is changed?
 
A

Al Campagna

tecas,
Use the afterUpdate event of the first combo, and do a Requery against Combo2.
--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."
 
Top