Sorting a continous form on the fly

[Mr Wonderful]

I have a sub-form with 5 fields named A-E
I have a combo box on the form named cmbSortBy with options for A-E
Currently trying to use a case select for restablishing the sort order on afterupdate
Select Case Me.cmbSortBy
Case "A"
Me.OrderBy = "A"
Me.OrderBy = True
Me.Requery
etc...

This issue is getting the form to re-draw after update. Ideas?

 

[MajP]

Is this a typo
Me.OrderBy = True

if not
Me.OrderByOn = True

 

[Mr Wonderful]

UGHHHH!!!! I'm an idiot