Filtering and Data Entry - Part 3 (article date: Apr-3-2009)

This example was built to demonstrate a simple use of a Microsoft Access 2007 datasheet 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 uses VBA code for all logic, see Part 2 of this series of articles for this same example using primarily embedded macros and very little VBA code.

Screenshots

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 might be easier to start with if you are more familiar or comfortable with writing macros. In this example look at the code behind each form and in the one module.

If you liked this article feel free to send us a note or donate a few dollars using paypal. Click here to download the complete code example.