Sorting multiple fields at one time on a form 1

[JamesBBB]

Hi All,

I am a little confused about sorting on to fields within a form.

Basically I have a continuous form that shows an episode title, the series that its from its corresponding episode number.

I have a button that can sort the Series Number, however the episodes for each series are not in any order.

What I would like to be able to do is sort the episodes in order for each series.

The command on the button is:-

Me.Episode_No.SetFocus
DoCmd.RunCommand acCmdSortAscending

However this, obviously ignores the episode number. I assume I would need to perform some nested sort, but long searching within the forum has revealed no help (probably my search wording).

Any help would be very gratfully received.


James

 

[mp9]

Try:

Me.OrderBy = "[NameOfSeriesNumField], [NameOfEpiNumField]"
Me.OrderByOn = True
DoCmd.RunCommand acCmdRefresh

http://www22.brinkster.com/accessory/

 

[JamesBBB]

Hi MP9

Works a treat, many many thanks.

I never thought of using orderby, however its firmly entranched in my memory now.

thanks again

James