how to refresh combo boxes dependant upon the choice in another

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

tecas - 17 May 2007 15:48 GMT

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?

Reply to this Message

Al Campagna - 17 May 2007 16:02 GMT

tecas,
Use the afterUpdate event of the first combo, and do a Requery against Combo2.

Signature

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

>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?

Reply to this Message