Filtering and Data Entry – Part 1 (article date: Apr-3-2009)
This example was built to demonstrate a simple use of one form with a listbox control that lets the user filter sort, add, edit and delete records and they can optionally open the record using another form which allows form-based data entry. This example is built in Access 2000 and uses a fair amount of code to help with things like sorting and filtering.
How it works
To understand how it works you will need to look at the code.
The code is relatively easy in this example. Part 2 and 3 show of this series of articles show an Access 2007 approach using a datasheet instead of a listbox control so take a look at those articles for other options.