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."
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Heirarchical Combo Boxes? 3
Combo Boxes 4
How to refresh a combo box without closing a program? 4
Using combo boxes to filter data on a form ... 4
Invisible/Hidden Combo Boxes? 12
Combo Box ? or Any other way to do this? 2
Controlling Combo Box display selection 1
Combo Box1 Choice Enables Combo Box2 1

Top