Bookmark Listbox

[humpydumpy2000]

Hi all,
I have two forms, the mainform contains a listbox where all the records I entered will be displayed and the other form which I use to enter a new record. Whenever I post a new record the listbox on the mainform refreshes however it sticks only to the first record. How is it possible that everytime I post the listbox will go to the latest record?

Any help would be greatly appreciated

 

[petrosky]

Hi humptydumpy2000,

I haven't tested but perhaps in your main form refresh action you could try something like this.

Me.YourListBox.Selected(Me.YourListBox.ListCount - 1) = True

Remember- It's nice to be important,
but it's important to be nice

 

[humpydumpy2000]

wow thank you very much! I worked the way I want it cheers