Auto dropdown

[Guest]

Combo box on continuous form
AutoExpand True
LimitToList True

In order to display the records following what the user is typing, I want to
drop down the combo box when the user begins typing. I tried doing it on the
control's Enter event, but since this is the first control & it has the focus
when the form is opened, that results in the combo box dropping down when the
user goes to a new record (OK, but not ideal) and each time the form is
opened (definitely not OK).

If, on the other hand, I suppress the dropdown programmatically by using a
boolean variable so that it does not drop down when the form is opened, it
does not drop down if the user attempt to change the first entry.


What I need is something that can drop down the box on the FIRST keypress in
the combo box. I tried putting on the Change event, and that seems to work
OK. It does not appear to re-drop down the box each time another key is
pressed, but I don't know if the dropdown method does anything if the control
is already dropped down.

 

[Ken Snell \(MVP\)]

The Change event is the one to use. The code will run every time the user
presses a key, but nothing will occur if the list is already dropped down.

 

[Guest]

Thanks. That's what it looked like (functionally) to me, but since I just
wanted to make sure I'm not triggering something unnecessary on every key
stroke.