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

Fill Second Field from Combo Box
Access Combo Box


Updated On 5/19/2017 5:50:12 AM

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


A Better Way to Fill Form Field from Combo Box

Save Multiple Values From Lookup Lists

Here's a better way to fill a field that gets its value from a combo box.  Below, we are getting the shipper's account number from the Shipper_Combo field (3rd column in the list, 2nd column counting from zero).  Notice the Control Source for the Account text box: =[Shipper_Combo].column(2).



Our programming team has 15 members containing a wide variety of technical database knowledge and programming experience. Experts in small business management and scientific database programming.

Did you know you don't need to move to SQL/Server to run and manage your Access database on the net. There are many alternative solutions. Among them are Amazon's AWS cloud services and various hosting services in nearly every state.


So,  now you know the correct way to fill in a text field from values in a combo box.  No visual basic code is required!

This same technique with minor modifications can be used to display numerous fields from dropdown list boxes on the form in unbound text fields.

Download an Access database which demonstrates this Combo Box/Text Field feature. Here's an image of the demonstration download:

Download Fill Form Fields Example

Additional Information Dealing with Fields on Access Forms:

 

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









A Blue Claw Database Design Article:

ODBC Links To Other DB Systems
 





Blue Claw Database Design Downloadable Tutorial:
Use Global Variables as Parameters  





A Blue Claw Software Design Template:

Farmer's Feed Inventory Tracking Database
 

Contact Information

Copyright 2000-2017 Blue Claw Database Design

Microsoft Access 2007, Access 2010, MS Access 2013