Sorting Data Subform in datasheet view

  • Thread starter Thread starter Norman Belanger
  • Start date Start date
N

Norman Belanger

Aside from using the shortcut, how do I do sort fields in datasheet view
form by clicking on the headers?
 
Hi Norman

You can't do this in datasheet view, but you can create a continuous form
that *looks* like datasheet view. Then, in the header section, you can
assign event procedures to the Click events of the header labels. For
example:

Private Sub lblHdrSurname_Click()
Me.OrderBy = "Surname"
Me.OrderByOn = True
End Sub
 
Back
Top