Auto dropdown

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
 
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.
 
Back
Top