Sort in VBA (2007)

Topic

New Reply

Likely to be a simple one, but i’d like to add a sort to a filter, I’ve got on a button, but the help file is confusing me.

Here’s my filter;

Me.Filter = “tblMain.Revdate < Now()"
Me.FilterOn = True

I'd like to sort first by [revdate], then by [score].

TIA

Reply | Quote

Replies

Add the following lines:

Me.OrderBy = “revdate, score”
Me.OrderByOn = True

Reply | Quote

Cheers Hans.

That is FAR simpler than what I was able to find in Help.

Many thanks

Reply | Quote