From: matthew on 4 Apr 2010 15:07 "Jane" <Jane(a)discussions.microsoft.com> wrote in message news:C4DC35E5-80B8-4729-AF24-41B09EABEBB3(a)microsoft.com... > Hello everyone > > Is it possible to sort a continous form by more than one field > > I have this > > Private Sub SortAZ_Name_Click() > Me.OrderBy = "Surname" > End Sub > > But I would like something like this > > Private Sub SortAZ_Name_Click() > Me.OrderBy = "Surname" and 1stname > End Sub > > Is this possible > > Thank you for your help if you can offer any tips > > Jane |