You can return multiple values from a VBA procedure by using a simple User Defined Type (UDT). Though, some situations require a "complex" UDT.

You can "return" multiple values from a VBA procedure by passing your arguments by reference.

There are two basic ways to handle events in Microsoft Access: via {Event Procedure] Event Handlers (i.e., Subs) and Function calls from the Property Sheet.

You need event handlers to write event-driven code. This tutorial will help new users get up to speed and may even teach seasoned pros a thing or two.

You can "return" values from a Sub via a parameter passed by reference. What does that look like and when should you use it? Let's explore.

Every Function in VBA has a return type even if you don't explicitly define one. In fact, there are *FOUR* different ways to declare function return types.

Almost every Sub could be a Function...but that doesn't mean it's a good idea.