Autocompleting a Field for a Record Search.

[markvan]

How can I create a search for records that automatically filters to the letters entered.
eg. List of names like "Doofus, Dopelheimer, Dorcas"
that will come up when the search field is simply "do"

Better still, if I enter "do" it would autocomplete to give me "doofus", "dop" would autocomplete to "Dopelheimer" etc.

Suggestions please? TIA!

 

[Guest_imported]

I am working on an Access project which requires me to print Crystal Reports from Access with parameters supplied by some tables in Access. Since I don't have VB installed on my machine, and it may not be installed in the near future, I need to use just Access to do the job. What object shall I use? Many Thanks.

 

[jedlag]

In the Criteria line in the query type:

Like [Enter the first letter of last name to search by: ] & "*"

Sorry, don't know about an "autocomplete".

jedlag