Dropdown Event on a Combo Box?

[Paul H]

This dates back to an earlier thread. My combo boxes start out with zero rows till the user keys in the first character, so clicking on the dropdown button shows nothing to choose from. Is there a way to capture this action (Dropdown) and check for the number of rows? If it equals zero, I would like to send the user a message key the first character. I can't find an event that would trigger this.

[ItsMe]

I believe you would have to use the Combo's RowSource to take a separate trip to the data and count the Records. That is what I have done in the past.

[Paul H]

I can do that part, but I don't know how to capture the dropdown event.

[ItsMe]

Dropdown is a Method and there does not appear to be an Event to determine if this is happening. Also, the Dropdown Method does not have a return value so there is not way, for instance, to see if Dropdown = True. However, a combo needs to have focus before the Dropdown Method can be executed.

[Paul H]

Yeah, I though of a few events to handle it, but only want the message sent when the dropdown displays zero rows.

Thanks for your feedback.