Need help with autocomplete combo box by repeating first letter...

[mullet]

New access user here. I'm trying to set up a combobox to autocomplete based on the first letter only. For example, in a name field, if I press A once it will fill Adams, by pressing A again it will move to the next name - Allen, and etc. I see this function in web forms all the time when filling the US state field. Thanks for the help.

[bcofie]

I think you just have to bind combo box to field that has the names. see properties of combo box and change row source to a query that selects all records in the name field.

[mullet]

Thanks for the response. Assuming I followed your direction, this is not working. I created a simple query of the names field and set it as the row source but the combo box no longer pulls any names either typing or as a drop down box. Something is amiss. Further input would be welcomed. Thanks.

[bcofie]

See attached.

Hope this helps.
Ben

[mullet]

The database you sent does what mine currently does. If I type an "a" in the form, Adams comes up, if I type another "a" it just fills the form with "aa". I'm looking for the second "a" keystroke to bring up the next name that begins with the letter A. Any ideas? Thanks.