"On Key Down" property to search a list

[pgill]

I have a form that displays customer information in a list. I have a text box to search for a specific customer in the list. What I would like to do is that as the user types the customer name it goes to the customer as the user types in the name. An example of this is in the index view of the help file. If you type in the letter 'b' it goes to the 'b' topic, as you type and you then type the letter 'r' (so now you have 'br') it goes to the topic begining with 'br' such as break. Should I use the "On Key Down" property and if so how should I code it? Can any one tell me how to do this? Thanks in advance.

[Rabbit]

Using the On Change event would be better. And since the textbox is not updated yet, you have to use the .Text property to call the current value rather than what's stored. As for finding the value to go to, use DLookup to find the bound value of the list.

[missinglinq]

Is there a reason you don't want to use a combobox? Why not simply let Access do all the work?

Place a combo box on the form. When the Combobox Wizard comes up:

Select "Find a record on my form based on the value I've selected..."
Next
Select the appropriate identifying field to appear in the Combo box
Next
Size the Combo box column
Next
Name the combo box
Finish

Now the user can use the dropdown arrow of the combo box to retrieve the data or simply start typing the identifying data in and the combo box will start to autocomplete the entry. Access actually calls this AutoExpand (don't know why they don't call it AutoComplete!) but it behaves in the manner you desire! When the correct entry is found hit <Enter> and the appropriate data should be retrieved.

Welcome to TheScripts!

Linq ;0)>

[pgill]

Thank you all very much for your input. It looks like what I need. I'll give it a try. Thanks again for your time and input.