Hide Inactive Customers from Combo Boxes

In this video, I will show you how to hide inactive customers from showing up in combo boxes on your various forms, such as your order form. If the customer is dead or has moved out of the area, and is no longer an active customer, you don't want to see them in every combo box, BUT you shouldn't delete their record either.

Luis from Santiago, Chile (a Gold Member) asks: I have about 10,000 customers in my database. Around a third of them are no longer active (died, moved out of the area, etc.) however they still show up in my combo boxes. I don't want to delete these customers for accounting purposes, so how can I hide them?

Members

Members will learn how to have that customer's record still show up in the combo box for old orders even though that customer is marked inactive. We will also learn how to switch the customer list box to show just active or ALL customers.

Maggie from Williamsport, Pennsylvania (a Gold Member) asks: If a customer is marked inactive, their name no longer shows up on any of the orders they have. How do I keep their name on the order but not have it show in the combo box for new orders? 

•  Extended Cut Video - Silver
•  Gold Member Template Download - Gold

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!

Links

• Relational Combo: https://599cd.com/RelationalCombo
• Soft Delete: https://599cd.com/SoftDelete
• SQL Basics: https://599cd.com/SQLBasics

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

microsoft access, ms access, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #instruction, #learn, #lesson, #training, #database, hide inactive records, Combo box, select only active records but allow view of inactive records