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
How to Make a Listbox in MS Access Part 1: Single-selection
How to Create a Multi-Column Combo Box in MS Access, Adjust the Width and Bind it to the Table
How to Use Form and Subform Variables in Microsoft Access
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 Use the Tab Control in Access: Tabs with Subforms Example
MS Access Option Groups - How to Use Radio Buttons
How to Use Reference Expressions to Get Form Values in MS Access
How to Use Nz in Microsoft Access to Handle Null and Empty Values
After Update on Form Controls in Microsoft Access

Interested in transforming your career or finding your next gig?

Want my team to do a project for you? Let's get to it!

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

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

Follow me on social media:

Get Microsoft Office including Access:

Got a YouTube Channel? I use TubeBuddy, it is awesome. Give it a try:

#msaccess #vba

[neshaponesixty]

Thank you for this. It had never occurred to me that it was possible to reference the other unbound columns. As indicated in your video description, I was looking up values that were already available via the combo box.

[ecco]

This is great. Works very well for getting values from a table (via form list box) to use as query criteria without writing a custom function or running script to modify the query SQL. But I'm also confused now. Control.Column is a VBA property. It's not listed in the Expression Builder yet works fine in the Control Source property of a text box on a form. But it can't be used in query SQL. I guess that just means that VBA properties can be used in form controls' Property Sheets. I thought I was limited to what is in the Expression Builder.

[mitchellfolbe]

Trying to make an tourney bracket using combo boxes. This is a good step. Thanks.

[ddfkysp]

I want to enter the monthly performance of the personnel in Access every month, of course, by uploading the Excel file, but I want the performance of each month to be in exactly one column and by using the personnel code, the performance of each person should be placed in front of him. Please use the combo box to select the month of performance. Thankful

[argieamora]

Good day Sir, I am looking to one of your videos on how to show records in a joined query with missing values from fields. I have three tables Activity, Participant, and Junction of these two tables. I want to show all activities attended by a certain participant. The query works if there is no missing value in the fields of the participant table. If the participant got a missing value(ex. last name) it will not return the activities attended by that certain participant. I hope you can spare some time for this problem. Thank you.

[digitalentrepreneur]

If I have a list box and want to use a update query to retrieve the values and update them to an existing cell. What criteria could I use?

[rogerioc]

Hi Sean! I have a question. How do I retrieve a column value without using vba? I ask this because my intuition says it shoud be easy, but I haven´t found any way to do this without vba. Thanks

[justinlangdon]

Sean, How do I store these values into my table?