"moving" selected listbox value

[anasazii]

Greetings everyone!

I have a form that users enter a persons' first name, middle, and last. I then query the database to see if that name or one similar is found. If it is, I open a form showing that information and like the 10 closest records near the initial matched record in a listbox. (Actually, all records from the db are returned in sorted order, and then I set the selected value to the "matched" record)

Here's my question. Sometimes the matched, selected,record is way at the bottom of the list and hard to see. Is there anyway to "move" the selected record so that it appears at the "top" of the listbox, and the user would not have to scroll at all to get to it? I still want to be able to scroll through the values if necessary.

Hope this makes sense. Thanks in advance for any suggestions!

Janel

 

[pgk]

Hi Jane,
I don'tthink you can change the order in the list box. but if you were to set the selection to the matched record, that would highlight the particular record and make it visisble to the user.

Hope it helps. Let me know if you want furhter help.
With regards,
PGK

 

[anasazii]

Hi PGK!

Thanks for your response!

"set the selection to the matched record, that would highlight the particular record and make it visible to the user"

This is what I'm doing right now, but when the listbox appears the selected value is sometimes way at the bottom and barely visible to the user.

My question really isn't about changing the order in any way, but moving that selected value so it appears more towards the top, and the user doesn't have to scroll to find it.

Thanks,
Janel (not Jane)