listbox lightlight

[kingsgambit]

I have posted a simular question before but not alot of response. so I rewording it.
I have a listbox on a form in the header, when the user clicks on an item it finds and shows the record in the form details. the list contains alot of book titles.
I want to put a textbox on the form so if the user types a book title it will hightlight the book in the list and show the record in the form.
The reason for this is a book has several versions so by finding th ebook in the list they can then choose the version they want

 

[Jack Cowley]

If you use a combo box instead of a list box you can start typing in the combo box and the combo box will automatically move to the correct record. The more letters you type into the combo box the closer Access will come to the title you are searching for.

hth,
Jack

 

[kingsgambit]

I have tried this and could be a good solution, there are a couple of points if you help.
I need four search fields, so I would put four combo boxes on the form, is there a way I could put a button on the form to clear whatever to combobox was showing from the last search so they can start a new search.

 

[dcx693]

You can "clear" a combo box by setting it's value to Null like this:
Me.ComboBox=Null
or you can set the combo box to a specific value in the list. When designing search forms, I like to add the <<All>> choice to the top of my combo boxes so the user knows that by not changing that choice, he/she will get everything in that category.