Automatically Scroll to Bottom of List Box

[infinitx]

Hi,

I have a list box that displays values from a field in a table. I was wondering how I can make the list box scroll to the very bottom of the list automatically so the user can see the latest values that they have entered?

Thank you!

 

[WayneRyan]

infinitx,

You can Select it, then Deselect it:

Me.lstStubs.Selected(Me.lstStubs.ListCount - 1) = True
Me.lstStubs.Selected(Me.lstStubs.ListCount - 1) = False

Or maybe you could use the DESC in your SQL to sort it.

Wayne

 

[infinitx]

Wayne,

Thanks a lot. I have one question. How would a sample SQL look like with the sort order specified as DESC?

Thanks again!

 

[infinitx]

Nevermind, I got it!