Understanding a Form's Internal Field List in Access

In this Microsoft Access tutorial, I'm going to teach you how to update a form's internal field list so that when you add fields to an underlying table or query, the form can then recognize them.

Allan from Roseville, California (a Platinum Member) asks: I thought you said as long as a field was in a form's underlying table, you could Access the value of that field from VBA without having to put it as a control on the form. I added a couple of new fields to a table, and I'm trying to reference them in calculations in my code, but I'm getting "Variable Not Defined" errors. What's the deal?

Prerequisites

• Intro to VBA

Recommended Courses

• Access Developer Courses

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

access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, form internal field list, update form field list, add fields to form, variable not defined, form field variable, can't access form field variable from vb code