Class Modules Great Intro to Class Programming in VBA Former Access MVP Ben Clothier's primer on class programming in VBA should be required reading for all Access developers.
Class Modules Caching Object Instances in VBA Classes Simplify the object initialization code in your class modules without sacrificing performance using this easy technique.