Office Pro Sorting a Listbox Using Command Buttons

Today’s guest blogger is Daniel Lamarche. Daniel is the Training Director at ComboProjects,Microsoft Office 2010 Pro, which specializes in providing custom training solutions in Microsoft Office products. I always thought it was cool to be able to sort a list by clicking the column heading once,Office Home And Stude/nt, for ascending order then once more for descending order. A while ago I decided to tackle this feature in an Access form. The buttons above the field names are used to sort the list. The triangle pointing down means the column is in descending order. Clicking on it again will sort that column in ascending order and the triangle will be pointing up. Like you are used to. This project required a basic understanding of Access SQL and concatenating strings. When you configure the Listbox using the Row Source property to specify the data that will appear in the list you are in fact creating a SQL statement. Read the rest of the article and download a sample database here: Send your Power Tips to Mike and Chris at accpower@microsoft.com. <div