Home  Fees/Services  Access Templates  Tutorials  Tutorial Downloads  Articles  Search  Contact  Privacy  Links

Include Multiple Fields in DropDown List
Access Combo Box


Updated On 4/21/2017 5:25:23 PM

Combo Box Tutorial






Combo Box Tutorials
Fill Form Field Code
Combo Box: All/Any
Dependent DropDown
Cascading Combo Box
ComboBox Multiple Items
Lookup List Best Way
Lookup Lists 1 Table
Faster Combo Boxes
Table-based Combos
Y/N Drop Down List


Multiple Values From Dropdown List

Second Field From Lookup List/Drop Down List Box



Microsoft Access is a fully capable database and it's primary limitations is the number of concurrent users it will support. Generally, we recommend a limit of 10 to 15 users.

We create databases large and small. Some of our databases help run entire small businesses. We also handle unique businesses such as flyrod manufacturing, cheese making, marina management, and cable tv inventory.


Let's expand a previous example drop down list example and suppose that we have account numbers associated with each shipping method and that these account numbers (for whatever reason) can change over time. Therefore we want to capture the current account number in the widget shipping record. Here is how the combo box looks in operation:


Populate Multiple Field Drop Down List

Now I bet you want to know how I got the account number to jump from the drop down list over to the account field.

New! Download Access example of Filling Data Fields From Combo Box.

It is fairly easy - add an Event Procedure to the After Update event trigger of the combo box. Here are the lines of code that go into the procedure:

Access Multi-Field Drop Down List Techniques

Need help getting multiple values from a combo box? Give us a call and we will solve the problem or there is no charge! $100 1/2 hour.
410-708-1417

The only line that you actually have to type is the one starting with Me...  Note that Column(2) contains the account number in the combo box.  Combo boxes start counting fields at zero.  The actual fields are: Shipping_Method_ID; Shipping_Method; Account.

Don't miss our tutorial downloads for additional help with combo boxes.








A Blue Claw Database Design Article:

Cloud-Based Access Database
 





Blue Claw Database Design Downloadable Tutorial:
Bar Chart / Bar Graph Download  





A Blue Claw Software Design Template:

Order Processing Case Study
 

Contact Information

Copyright 2000-2017 Blue Claw Database Design

Microsoft Access 2007, Access 2010, MS Access 2013