Combo Box linking

[Dave Hawks]

I use a combo box to allow users to enter there names on a form. The combo
box is derived from a query on members names. When they click on the drop
down arrow at the right of the box a msg Box appears asking them to enter the
first initial of their surname. After entering the letter and clicking OK the
drop down list appears showing all surnames begining with that letter and
they then select their name and it appears in the box.
With some less computer wise users they click in the box to the left of the
arrow and start to type their name instead. As soon as they type the first
letter the query box opens and they then click OK or cancel to clear it and
must Tab out of the field and start again.
Is it possible to ensure that the Msg Box appears if you click directly into
the box or on the drop down arrow.
Thanks

 

[Klatuu]

Seems a bit clumsy for the users. If you use the Auto Expand property set to
Yes for your combo, as soon as the user types the first letter of his
surname, the first surname that begins with that letter will appear in the
combo. the Auto Expand is what is often called "typeahead". It keeps
chaning as you enter letters.
If you want the combo empty before they start, you can put a line of code in
the form's Current event:

Me.MyCombo = Null

 

[Barry Gilbert]

I agree. If you're doing this because your list is too long to load when the
form loads, you could load it dynamically. Allen Browne has a nice article on
how to do that:
http://allenbrowne.com/ser-32.html

Barry

 

[Klatuu]

Thanks, Barry, I forgot about that trick. I haven't used it, but I read it
and it seems like a great approach.

 

[Dave Hawks]

Thanks for the ideas.


--
Dave Hawks

Thanks, Barry, I forgot about that trick. I haven't used it, but I read it
and it seems like a great approach.