combo box drop down

[alan]

How do I get the second combo box to expand once the user
makes a selection on the first one? Thanks

 

[Frans van Zelm]

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

 

[Stephen Lebans]

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.

 

[Frans van Zelm]

Hi Stephen,

You are absolutely wright. Please don't ban me. ;-)

Frans