Access controls let you create powerful forms that can take care of almost any need. From combo boxes and list boxes to manipulating controls with Visual Basic for Applications, Access has the tools to get the job done. For more information on using VBA and collections, see the following chapters:
Chapter 2, “Coding in Access 2000 with VBA,” adds insight to using the various commands found in VBA.
Working with collections, although at first confusing, can open the whole Access world after you understand it. Chapter 4, “Looking at the Access Collections,” shows you the collections, along with their properties and methods.
In Chapter 8, “Using Queries to Get the Most Out of Your Data,” you learn how to optimize your queries and make them really work for you, as well as when and where to use SQL statements rather than prebuilt queries.
Chapter 9, “Creating Powerful Forms,” gives you additional techniques for swapping out subforms and using code behind forms for generic purposes.
To learn additional techniques for using multiselect list boxes, see Chapter 11, "Creating Powerful Reports."
3.15.219.80