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 Comma...
How to Make a Listbox in MS Access Part 1: Single-selection
• How to Make a Listbox ...
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-...
How to Use Form and Subform Variables in Microsoft Access
• How to Use Form and Su...
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 Subfor...
How to Use the Tab Control in Access: Tabs with Subforms Example
• How to Use the Tab Con...
MS Access Option Groups - How to Use Radio Buttons
• MS Access Option Group...
How to Use Reference Expressions to Get Form Values in MS Access
• How to Use Reference E...
How to Use Nz in Microsoft Access to Handle Null and Empty Values
• How to Use Nz in Micro...
After Update on Form Controls in Microsoft Access
• After Update on Form C...
For developers looking for a new role, check out and sign up:
www.toptal.com/qKaO2b/worlds-...
Needing to hire technical resources for your project? Get the best:
www.toptal.com/qKaO2b/worlds-...
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 www.mackenziemackenzie.com/
Follow me on social media:
/ mackenziedataanalytics
/ seamacke
/ seamacke
/ seamacke
/ psmackenzie
Get Microsoft Office including Access:
click.linksynergy.com/fs-bin/...
Got a KZitem Channel? I use TubeBuddy, it is awesome. Give it a try:
www.tubebuddy.com/seanmackenz...
#msaccess #vba
Негізгі бет How to Retrieve Any Column Value from a Combo Box or List Box in Microsoft Access
Пікірлер: 28