CHAPTER 29
Advanced Data Access with VBA

---

IN THIS CHAPTER

• Using a combo box to find a record on a form
• Using the form's filter options
• Using parameter queries to filter a form

---

In the previous few chapters, you learned the basics of Access programming, reviewed some built‐in VBA functions, and experienced the various VBA logical constructs. You learned about DAO and ADO and how to access data in tables and queries through recordsets. You also learned a lot about forms and queries.

In this chapter, you use all this knowledge and learn how to display selected data in forms or reports using a combination of techniques involving forms, Visual Basic code, and queries.

---

ON THE WEB

In the Chapter29.accdb database, you'll find several forms to use as a starting point, and other completed forms to compare to the forms you change in this example. All the examples use a modified version of frmProducts or tblProducts.

---

Adding an Unbound Combo Box to a Form to Find Data...