O'Reilly logo

Access™ 2007 VBA Programmer's Reference by Armen Stein, Geoffrey Griffith, Rob Cooper, Teresa Hennig

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

15.5. Summary

VBA and SQL are both powerful tools for you to use in your Access applications, and they work very well together. The techniques explained in this chapter enable you to add instant sorting to column headings, provide easy record selection on continuous forms, build smart cascading combo boxes that change their drop-down lists based on other selections, prompt your user for report selection criteria without using parameter queries, and change the SQL statement inside saved queries. With these features, your Access applications will be more flexible and easy to use.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required