Summary

We really covered a lot of territory here, and you just had your first taste of connecting VBA code to the database. We started with simple form examples and then saw the power of ADODB objects not only to connect to the database, but to save hundreds of lines of programming code. You also saw how to use these objects to help present formatted outputs of the resulting recordsets. In many ways, the rest of this book will explore the power of these objects.

We now turn our attention to building procedures and learning how they can interact with each other.