>>>
>>>I understand where you're going with the sql but the trick for me is to have the listbox set to the bottom of the file as if the user had 'arrowed' all the way down tothe bottom.
>>
>>
Ah Tim,
>>I got the quesition wrong. Then forget the SQL (still you can use it if you want). What you need is to set Listindex to Listcount :
>>
>>
with thisform.myListBox
>> .ListIndex = .ListCount
>>endwith
Cetin
>
>That did it, thanks.
>when would one actually have to use sql in the resource?
If me then always :)
Cetin