Trigger an event ONLY when arrow of combo box is clicked

[accessilliterate]

Hi,

Here is a question for the real experts out there. I have searched and read everywhere I can and can not find ant reference to my problem.

What I need is to be able to trigger an event ONLY when arrow of combo box is clicked. Not when it gets focus or anything like that but when the actual arrow at the right hand side of the combo box is clicked to open it.

Is this possible and if so could someone be so kind as to tell me how to do it.

If you can do this for me then I would owe you big time.

Thank you,

Access_illiterate

 

[Brambojr]

What is the purpose in doing this??

Around here you seldom get a response without staitng the purpose . . . (experience talking here). It allows them (us) to devise another solution you may not have thought of.

So what are ya trying to do anyhow? Brambojr

 

[JimHorton]

Acc,
The only way I've done this (which is a pretty good way, I think) is to create a button.
Use Marlett font, set button caption to '6'. This translates to the exact arrow as the combo box arrow. Put the arrow directly over the combobox arrow.

You can't tell the difference. Period.

In the button click, do: (this taken from an actual instance, change names accordingly)
Me.cboSrchProd.SetFocus 'must set focus to combo box first
Me.cboSrchProd.Dropdown 'drop it down

Then, of course, insert the code to do what you wish to do anywhere in there.
--Jim