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

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

Cascading Dependant combo boxes 0
subform combo box update, access 03 2
Dependent combo boxes issue 1
Combo box choice outcome 2
List Box Query - Forms 3
how to show data only from selected combo boxes ? 0
Combo Box 3
Go to combo box missing 3rd option 2

Back
Top