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
[ Ссылка ]
For developers looking for a new role, check out and sign up:
[ Ссылка ]
Needing to hire technical resources for your project? Get the best:
[ Ссылка ]
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!
Contact form you can find at [ Ссылка ]
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
![](https://i.ytimg.com/vi/7s2xdpFpYwk/maxresdefault.jpg)