Why Module over VBA behind a form

[Zorro1265]

When should you try to make a module instead of just putting the full code behind an even on a form? I am trying to learn VBA and wonder when and where each is best used.

Thanks!

 

[Rohdem]

Subs and functions in modules can be called from anywhere in the database, including queries and reports. This is useful so you can reuse code rather than putting it on each form and bloating your database with code. Mike Rohde
rohdem@marshallengines.com