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

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.

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

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.

Great tutorial as always!

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?

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

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.

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

great

thanks