Listbox Display Jumping When Adding Record

[Sorrells]

I have a listbox that records are added into. The listbox can hold 16 records before it is filled. When a 17th or greater record is added, all the previous records are hidden with only the new record showing.

I would like for at the 17th record for it to then:
- display the last 8 records
- and add one more to it, making the last 9 records displayed

When the listbox becomes full again, I'd like the same sequence repeated.

I cannot figure out how to do this, everything I try has the box looking like it is 'jumping' around and my users are very unhappy with it.

Does anyone have any suggestions?
Regards, Sorrells

 

[Sorrells]

Boy, would I like to change the title of this thread!!

It is a subform that is treating me cruelly, not a listbox.

My apologies. Still would appreciate help of course!
Regards, Sorrells