Create Drop-Down Lists in Access + VBA Trick

In this Microsoft Access tutorial, we will explore the concept of creating drop-down lists, known as combo boxes in Access, for streamlining data entry. You'll learn how to create value list and relational combo boxes. I'll guide you through setting up basic combo boxes and discuss the pitfalls of using the lookup wizard. Additionally, a developer-level tip on automating combo box drop-downs using VBA is included. This video is tailored for beginners, with insights for intermediate users and developers to enhance their skills.

Members

There is no extended cut, but here is the file download:

•  File Download - Gold Members

Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the files from class plus get access to the Code Vault. If you're not a member, Join Today!

Prerequisites

• Access Beginner 1

Links

• Lookup Wizard
• Combo Box
• Value List Combo
• Relationships
• Relational Combo
• Find Record Combo
• List Items Edit Form
• Intro to VBA
• Tab Stop, Order, Cycle
• On Got Focus
• Update Queries

Recommended Courses

• Complete Access 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 Diamond Sponsors - Information on our Sponsors 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, drop down, dropdown, drop-down, combo box, combo box drop-down, beginner combo box, combo box tutorial, value list combo box, relational combo box, combo box vs list box, lookup wizard, avoid lookup wizard, combo box VBA, VBA drop down, on got focus combo box, value list edits, combo box default value, combo box properties, combo box event, AutoComplete combo box, combo box state, state combo box, set focus combo box, combo box tab order