How to Return Multiple Values from a Function in Microsoft Access VBA @599CD
How to Return Multiple Values from a Function in Microsoft Access VBA  @599CD
Uploaded October 2026 | Updated November 2026, 1 day ago
In this lesson, we will walk through how to return multiple values from a VBA function in Microsoft Access using ByRef parameters. We will create a reusable customer lookup function that returns a Boolean success value while filling address, city, state, zip, and country variables, using a recordset to retrieve the related customer information in one place.

Holden from Honolulu, Hawaii (a Platinum Member) asks On my Order form, choosing a customer means I need to pull in their address, city, state, and ZIP code. I can get each piece separately, but I need the same information in several places and the duplicated code is getting messy. Is there a clean way for one routine to give my code all of those related values?

Silver Members & up get access to an Extended Cut of this video. In the extended cut, we will learn other ways to return multiple values in VBA, including using a Variant array, a Public Type with named members, collections, and a class module. We will walk through using collections as an alternative to ByRef parameters.

MEMBERS-ONLY EXTENDED CUT VIDEO:
youtu.be/wojvLR8La1M

CHAPTERS:
00:00 Introduction
03:13 Returning Multiple Values With ByRef
06:15 Prerequisites
07:10 Preparing the Order Form Fields
08:34 Looking Up Customer Data With a Recordset
12:25 Creating the Reusable GetCustomerInfo Function
15:24 Calling the Function From the Form
19:14 Alternative Methods for Multiple Outputs
22:23 Conclusion

BECOME A MEMBER:
YouTube: youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/join
or My Site: 599cd.com/THMember

LEARN MORE:
Return Multiple Values: 599cd.com/ReturnMultipleValues

PREREQUISITES:
Contacts: 599cd.com/Contacts
Invoicing: 599cd.com/Invoicing
Intro to VBA: 599cd.com/IntroVBA
Create Function: 599cd.com/Function
ByRef v ByVal: 599cd.com/ByRef
DLookup: 599cd.com/DLookup
Status Box: 599cd.com/Status
Recordsets: 599cd.com/Recordset
Scope: 599cd.com/Scope

LINKS:
DLookup Tricks: 599cd.com/DLookupTricks
Faster DLookup: 599cd.com/FasterDLookup
TempVars: 599cd.com/TempVars
Scope: 599cd.com/Scope
Arrays: 599cd.com/Arrays
Class Modules: 599cd.com/ClassModules

RECOMMENDED COURSES:
ByRef vs ByVal in Access Developer 25: 599cd.com/ACD25
Custom VBA Functions in Access Developer 17: 599cd.com/ACD17
Recordsets in Access Developer 16: 599cd.com/ACD16
Arrays in Access Developer 21: 599cd.com/ACD21
User-Defined Types in Access Developer 40: 599cd.com/ACD40
Class Modules in Access Developer 50: 599cd.com/ACD50

FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: 599cd.com/THFree
Blank Template: 599cd.com/Blank
Contact Management: 599cd.com/Contacts
Order Entry & Invoicing: 599cd.com/Invoicing
More Access Templates: 599cd.com/AccessTemplates

DIAMOND SPONSORS:
More info on our Sponsors: 599cd.com/DiamondSponsors

ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: 599cd.com/Free1
How to Use Access in 30 Minutes: 599cd.com/30Minutes
$1 Access Level 2: 599cd.com/1Dollar
Donate to my Tip Jar: 599cd.com/TipJar
Merch Store! Get your swag here: 599cd.com/Merch
Get on my Mailing List: 599cd.com/YTML
Contact Me: 599cd.com/Contact
TechHelp: 599cd.com/TechHelp
Consulting Help: 599cd.com/DevNet
Twitter: twitter.com/LearningAccess
en.wikipedia.org/wiki/Microsoft_Access
products.office.com/en-us/access
microsoft.com/en-us/microsoft-365/blog/access

KEYWORDS:
TechHelp, Access 2016, Access 2019, Access 2021, Access 2024, Access 365, Microsoft Access, MS Access, MS Access Tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, VBA function multiple return values, VBA ByRef parameters, return multiple values VBA, VBA Boolean function return, VBA recordset lookup, reusable VBA function, DAO Recordset, customer lookup VBA, VBA output parameters, VBA DLookup alternative

QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Live long, and prosper.
How to Return Multiple Values from a Function in Microsoft Access VBAWhat Happens Assigning DLookup Null to a Long Variable in Microsoft Access? Video Quiz D3.1Make This The First Screen Users See In AccessBuild a Flexible Inventory Management System with One-to-Many Relationships in Microsoft AccessReuse Access Forms Across Multiple AppsThe Access Regex Version GotchaWill Microsoft Access Ever Run On Android?Why Your New Combo Box Item Is MissingMicrosoft Access Account Balances Template - Release Update 3Regex Cannot Tell You If A ZIP Code ExistsWhat Happens Assigning DLookup Null to a Long Variable in Microsoft Access? Video Quiz D3.1Validate A Five-Digit ZIP Code With Regex
Computer Learning Zone |

How to Return Multiple Values from a Function in Microsoft Access VBA

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER