How to do searches.

[Ma3x323]

Hi,
I am a newbie on access. Here's the situation, I have a text box for typing in a word search and a list box right below it to show the possible matches. The list box shows all the words and when a specific letter(s) is typed, the list box will directly go to the possible word and highlight it. There is a specific term for this search but I forgot what it was.

I need help and maybe some tips.

Thanks in advance,
Feryl

"If you can't beat them, have somebody else do it for you."

 

[Guest_imported]

If I understand this right the term your looking for is
"Keyword Search"

 

[Ma3x323]

Forget about it. I figured it out but I do still have one problem. The list box sets the default as the item at the bottom and when entering a search, it starts from the bottom. It's like the alphabet is reversed. If anybody knows how to fix this please OH PLEASE help me.

Thanks,
Feryl

 

[fchan]

What is the row source of your list box? If your row source is a saved query you can set your query to sort ascending.

If your row source is an SQL statement, you can add ORDER BY "FieldName". The default is ascending.

 

[Ma3x323]

Alphabetizing is not really the problem. The problem is that when I do the keyword search, the first word it goes to is the most bottom one.

Examples:
Search: A
Abracadabra
Accurate
Alarm
Arctic <--- It highlights this first when A is typed
Bad
Nosy
Reply
Rude
Yankee
Zulu <-- highlighted first when no letter on Search:

Anybody know what's wrong?

Thanks in advance again
Feryl