narrowing choices while typing

  • Thread starter Thread starter rob c
  • Start date Start date
R

rob c

I need to set up a combo box that has multiple choices based on a table, but
then the choices are narrowed down by the characthers typed. Example:
List of choices
Door Repair
Door Install
Dryer replaced
Window Repair
Window Install
Winterize

If the user were to type "D", then Door Repair, Door Install, and Dryer
replaced would remain.
If the user then typed "o", then Door Repair and Door Install would remain
as choices.

Thank you
 
Rob

The Access combobox does what you describe, if the LimitToList property is
turned on (only valid values can be found), and if the (I don't recall the
exact name of this one) "Autocomplete" property is turned on.

Now, it doesn't limit to only "Door Repair" and "Door Install", but it does
jump the the point in the list where those are located.

Good luck

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Thanks, Karl. I can never remember that ... if only Microsoft had given it
the name I came up with...<g>.

Jeff B.
 
Back
Top