Pass a Form as Object Variable to Global Subroutine

In this Microsoft Access tutorial, you will learn how to pass a form as an object variable to a global subroutine using VBA. I will show you how to create a global function to change the form's background color based on the "IsActive" field, minimizing code duplication across multiple forms.

Clara from Pearland, Texas (a Platinum Member) asks: I have a field called "IsActive" on several of my forms, which can relate to customers, orders, products, and various other types of data. Is it possible to create a global function to set the form's background color to gray if the current record is not active? I would prefer to use a global function to avoid duplicating the code across multiple forms.

Prerequisites

• Intro to VBA
• On Current
• Create Function
• Scope

Links

• VBA Colors

Recommended Courses

• Access Developer Courses

Up Next

• Passing a Form, Part 2

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

Keywords

TechHelp Access, passing a form as a variable in VBA, Access VBA global subroutine, global function in Microsoft Access, VBA pass form to subroutine, setting form background color VBA, change form background color based on field value, Access form background color inactive records, VBA on current event, is active field VBA