Sorting Data Subform in datasheet view

[Norman Belanger]

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

 

[Graham Mandeno]

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