Jan 23, 2003 #1 Minuet Technical User Dec 18, 2002 48 CA Is it possible to program a command button in a form to, when clicked, sort records in ascending order?
Is it possible to program a command button in a form to, when clicked, sort records in ascending order?
Jan 23, 2003 #2 FancyPrairie Programmer Oct 16, 2001 2,917 US You will want to user the OrderBy property. Example 1, sorts by last name in ascending order. Example 2 sorts by last name in descending order. Example 1: Me.OrderBy = "strLastName" Me.OrderByOn = True Example 2: Me.OrderBy = "strLastName Desc" Me.OrderByOn = True Upvote 0 Downvote
You will want to user the OrderBy property. Example 1, sorts by last name in ascending order. Example 2 sorts by last name in descending order. Example 1: Me.OrderBy = "strLastName" Me.OrderByOn = True Example 2: Me.OrderBy = "strLastName Desc" Me.OrderByOn = True