Computer Learning Zone
Returning Multiple Values from Microsoft Access VBA Functions
23:47
Need one VBA routine to retrieve several related pieces of information, such as a customer's address, city, state, ZIP code, and country? This episode explores a clean Access VBA pattern for doing exactly that without scattering repeated DLookup code throughout your database.
Using a Boolean function result for success or failure and ByRef parameters for the additional values, you can keep…