how to refresh combo boxes dependant upon the choice in another

  • Thread starter Thread starter tecas
  • Start date Start date
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?
 
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."
 
Back
Top