automatic completion

[eran185]

i build a query that filter names.
i want that when the user start to write the name he want to find in the query , he will get a list of names that starting with the same letter he wrote
how can i do this thing in access ?

 

[Dennisk]

use a combo box on a form to list the names and refer to the combo box in your query's criteria grid.

 

[eran185]

thank's

thank's

 

[ianward]

Have a look in the sample database section - there is a very good example for search and sort - which does exactly what you are describing.

Ian