I have a button located at the bottom of a subform.When clicked the subform repeats. I want to setFocus on the field located at the top of the new sub-formso that the user isn't looking at the bottom of the new sub-form after clicking the button.

The users can enter any part number that is involved. These part numbers can start with letters or numbers, including some that start with zeros. I want a button the user can click after entering several part numbers that will sort the list so if there are a lot of parts listed, they can find them b...

Maybe I am wrong in how I should be sorting part numbers. What you are saying certainly makes sense. I apologize if I have been asking the wrong questions. 

I really appreacie all the help you have given me. Much appreciated!

It appears to be sorting the numbers as text instead of as numbers...

I'm still having trouble with part numbers that start with zero.This is my unsorted list...and this is after I run your last script...

The only problem I stilll have is part numbers that start with 0 like 015645 do not sort correctly.

Magus069,Thank you for your help trying to solve this sort issue. It has been solved.

Yes! That's what it needed. I changed "this" to PartsListBox and it works!Thank you so much!

First of all, I really appreciate your hep with this.i added tthe script to the Sort button but cannot get it to run when clicking the button.