A alan Apr 6, 2004 #1 How do I get the second combo box to expand once the user makes a selection on the first one? Thanks
F Frans van Zelm Apr 6, 2004 #2 Dear Alan, I will be banned from the group for this, but it works: Private Sub cboFirstCombobox() Me.cboSecondCombobox.SetFocus SendKeys "%{Down}" End Sub Mvg, Frans
Dear Alan, I will be banned from the group for this, but it works: Private Sub cboFirstCombobox() Me.cboSecondCombobox.SetFocus SendKeys "%{Down}" End Sub Mvg, Frans
S Stephen Lebans Apr 6, 2004 #3 Why would you advocate using SendKeys when the Combo control exposes a DropDown method? -- HTH Stephen Lebans http://www.lebans.com Access Code, Tips and Tricks Please respond only to the newsgroups so everyone can benefit.
Why would you advocate using SendKeys when the Combo control exposes a DropDown method? -- HTH Stephen Lebans http://www.lebans.com Access Code, Tips and Tricks Please respond only to the newsgroups so everyone can benefit.
F Frans van Zelm Apr 7, 2004 #4 Hi Stephen, You are absolutely wright. Please don't ban me. ;-) Frans