Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

dynamic dropdowns

Status
Not open for further replies.

cynaptic

Programmer
Sep 13, 2001
54
GB
Is it possible to set the contents of one dropdown based on another. i.e. populating a second dropdown based on the selection made in the first?
 
Yes, in the RowSource of ComboBox2, you would have a reference to ComboBox1. For example...

CombBox2.RowSource = "SELECT LASTNAME FROM tblCUSTOMER WHERE STATE = '" & ComboBox1 & "'"

Hope this is what you are looking...

prodevmg@yahoo.com
ProDev, MS Access Applications B-)
May God bless you in the year 2002.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top