Make Multiple Cascading Combo Boxes in Access Part 5

In this Microsoft Access tutorial, I will show you how to manage multiple cascading combo boxes by creating a series of small list item edit forms. This is part 5 of my series. You will learn how to efficiently add, edit, and delete entries for countries, states, counties, cities, and streets using separate forms, ensuring that combo boxes reflect appropriate selections dynamically. We'll also cover handling default values and using hidden fields to maintain parent-child relationships between records. Additionally, I'll demonstrate a method for preventing user inputs when the parent reference is missing. This is part 5.

Members

In the extended cut, we will create one big table to store all of the related data, including countries, states, and cities. I will show you how to set up an address level table for titles while consolidating all the data into a single main table. This approach will be similar to the helper data series, providing a more streamlined method of managing geographic information. The extended cut will be made available to Silver members and up, offering a structured approach to managing multiple cascading combo boxes with a unified data table.

•  01. Free Video
•  02. Extended Cut Video - Silver Members
•  Regular Database - Gold Members
•  Extended Cut Database - 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!

Update

• I answer a lot of the questions asked by students in this series in Quick Queries #34.

Prerequisites

• Multiple Cascading, Part 4

Links

• List Items Edit Form

Recommended Courses

• Access Developer Courses
• More Cascading

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, cascading combo boxes, list items edit form, edit records button, hidden fields, default value property, "Not In List" event, modal forms, parent-child relationships, troubleshooting forms, row source modification, on open event, NULL value check, combo box filters, practice coding forms, extended cut tutorial