MS Access search inq

[london01]

Hello everybody,

I'm very new to MS access and just to keep tracke of my dvd movies i created a database and a form to do different funtions..

just to start..
i like to create a search event that searches the database as you type, the search will be done on the title field.
i have a text field to enter a character/name to search for a movie. A listbox to display the results as i type more character in the text field.

not sure if i'm explaining it correctly but it would be like searching for a word in a dictionary. As you type the title of the movie it displays any title that comes close to what the user is typing.
example... if user types in "A" it would display everything starting with "A". and if the user types in "AV" everything starting with AV is displayed.. etc..
is this possible..

 

[willir]

A simple way to achieve this is to use a combo box.

Rather than change the exiting Title text field to a combo box which will be "bound" to the title field, it may be better to add a combo box and use the "wizard" to "find a record". This combo box will not be bound to a field - thus you will minimize the risk of accidentally over-typing the orginal tile with the one title you are sarching for.

The wizard will do most / all of the work for you which will simplify the task, and dazzle your friends.

Richard