Sorting within acFormDS

[mba1942]

I have a form thatour service volunteers can use to log their service hours. Entries are usualy made weekly and management uses the data to report monthly. I provide a "View Log" button so, as the month progresses, our volunteers can view the log entries and confirm they have entered all their weekly times.

MY code is as follows:
...
stDocName = "frmTimeLog"
DoCmd.OpenForm stDocName, acFormDS, , stLinkCriteria

The entries open in DataSheet view in chronological - input - order.

Is there a way to set a sorting parameter within the 'DoCmd' so all entries from each volunteer can be grouped together?

Thank you so much for your excellent help in the past and very timely response! MBA

 

[boblarson]

Set the sort order in the query so that you first sort by Time input and then by volunteer. An example would be: