combo box drop down

  • Thread starter Thread starter alan
  • Start date Start date
A

alan

How do I get the second combo box to expand once the user
makes a selection on the first one? Thanks
 
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
 
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.
 
Back
Top