>Ok, thanks Trey,
>
>I wanted to try and avoid having to loop through all the values, expecially since the RowSource table could contain upwards of 5,000 records... but, oh well... I'll see how your suggestion works.
>
>- Brian
>
>>
In that case, you should be able to go right to the record you want with a seek or locate in the Rowsource cursor and then call the listbox.refresh(). Moving the record pointer should move the item in the list as well.
FWIW, since you've got that many records, I would suggest that you use a grid instead of a listbox.
Insanity: Doing the same thing over and over and expecting different results.