How to Retrieve Any Column Value from a Combo Box or List Box in Microsoft Access

In this episode, we're going to look at how to get not just our bound values from Combo Boxes and List Boxes, but also how to get the values of any column on a selected row. This is an extremely handy method, as many programmers have "pre-loaded" many values into multi-column combos/listboxes. When on screen form or report calculations are required, they do not have to do a lookup on the database to get those same values.. .. they can just grab them from the on-screen combos/listboxes instead of having to do additional hits/queries on the database. You'll also watch me build a multi-column combo box and listbox from scratch in this episode, so you might like the techniques you find there as well.

Related Videos:
2 Ways to Create Command Buttons on MS Access Forms
   • 2 Ways to Create Command Buttons on M...  
How to Make a Listbox in MS Access Part 1: Single-selection
   • How to Make a Listbox in MS Access Pa...  
How to Create a Multi-Column Combo Box in MS Access, Adjust the Width and Bind it to the Table
   • How to Create a Multi-Column Combo Bo...  
How to Use Form and Subform Variables in Microsoft Access
   • How to Use Form and Subform Variables...  
How to Retrieve Any Column Value from a Combo Box or List Box in Microsoft Access
You are watching this video now!
How to Create a Subform in MS Access
   • How to Create a Subform in MS Access  
How to Use the Tab Control in Access: Tabs with Subforms Example
   • How to Use the Tab Control in Access:...  
MS Access Option Groups - How to Use Radio Buttons
   • MS Access Option Groups - How to Use ...  
How to Use Reference Expressions to Get Form Values in MS Access
   • How to Use Reference Expressions to G...  
How to Use Nz in Microsoft Access to Handle Null and Empty Values
   • How to Use Nz in Microsoft Access to ...  
After Update on Form Controls in Microsoft Access
   • After Update on Form Controls in Micr...  

Interested in transforming your career or finding your next gig?
https://system.billzone.com/careers.html

Want my team to do a project for you? Let's get to it!
https://system.billzone.com/smdeproje...

Want to get access to premium content made just for you and have a chat with me? Find me on Patreon :

  / mackenziedataengineering  

Want to work with me 1:1? Contact me today and book your free 20 min consultation!

Contact form you can find at http://www.mackenziemackenzie.com/

Follow me on social media:
  / mackenziedataanalytics  
  / seamacke  
  / seamacke  
  / seamacke  
  / psmackenzie  

Get Microsoft Office including Access:
https://click.linksynergy.com/fs-bin/...

Got a YouTube Channel? I use TubeBuddy, it is awesome. Give it a try:
https://www.tubebuddy.com/seanmackenz...


#msaccess #vba