|
||||||
|
Hide Inactive By Richard Rost 3 years ago 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? MembersMembers 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?
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
Keywordsmicrosoft 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
|
||||||||||||||||||||||||
| |||
Keywords: TechHelp Access hide inactive records, Combo box, select only active records but allow view of inactive records PermaLink Hide Inactive in Microsoft Access |