Userform Listbox change to show bottom rather than top entries of associated database?

[dellehurley]

Hi
I have a listbox in a userform which shows the connected database. Currently it shows the entries at the top of the database. There is a scroll bar on the side. This will go to the bottom (but never actually shows the final entry only the second last). Is there a way I can change the listboxs's to show the last rows ie. most recently added entries on the list rather than the top of the list and having to scroll down?
Dannielle

 

[dmt32]

hi,
couple of ideas

- change your add record code to insert new records in the first rather than the last row of your database

or

- after adding a record, sort the database so that latest date appears at top


Dave

 

[dellehurley]

hi,
couple of ideas

- change your add record code to insert new records in the first rather than the last row of your database

or

- after adding a record, sort the database so that latest date appears at top


Dave

I'll give it a go thanks