Feb 25, 2002 #1 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?
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?
Feb 25, 2002 #2 LonnieJohnson Programmer Apr 16, 2001 2,628 US 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-) http://www.galaxymall.com/software/PRODEVMay God bless you in the year 2002. Upvote 0 Downvote
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-) http://www.galaxymall.com/software/PRODEVMay God bless you in the year 2002.