How do I sort and filter records in a Form in Access 2007? To filter your records in your Form you can click in a field you want to filter by, say a city like Salt Lake City, and then on the Ribbon click Home Tab, to Sort and Filter group and click the Filter button. Here you'll have a listing of all cities including Salt Lake City. Simply uncheck the "Select All" box and then check "Salt Lake City" and only those records tied to this city will be displayed, but of course you'll have to navigate one record at a time. So if you have a total of 100 records and 11 were of Salt Lake City, then only the 11 will display and you can use the navigation buttons to toggle from one record to the next!

Purchase the training video and you can see this in action for yourself!