Understanding the collections and DAO used in Access is the key to understanding how to develop in Access. By understanding the structures, methods, and properties of the collections and objects, you can accomplish pretty much anything necessary that can't be performed with forms and queries.
The collections mentioned in this chapter are used throughout the rest of the book, so you get plenty of examples of how to put them into practice. Your next logical step is to read the following chapters:
Chapter 6, “Introducing ActiveX Data Objects,” shows you the other technology used for manipulating data with VBA.
Chapter 7, "Handling Your Errors in Access with VBA," shows you not only the basics of error handling, but also some advanced techniques. Error handling is something that needs to be used in most of your code.
18.188.152.162