I just want to say THANK YOU! Your post has allowed me to solve a problem that his been plaguing me for three days, i.e. getting a form to open in a particular sort order regardless of how the users may have sorted it in the past. That is to say, I needed the form to open in a "default" sort order and not the last saved sort order.

My OnOpen event procedure now has lines 2 & 4 of your code:

Me.OrderByOn...