Filtering and Data Entry – Part 2 (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 primarily embedded macros for the majority of the logic, see Part 3 of this series of articles for this same example using no macros and only 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 these examples. Part 3 might be easier to start with since it will show all the logic as code. In this example look for the embededded macros behind each of the buttons etc…

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..