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

Drop Down Box
Access Combo Box


Updated On 6/17/2017 2:40:05 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


Combo Box Examples

Combo Box Controls in Microsoft Access:  Access Combo box controls provide a flexible form control feature for making data entry consistent and user friendly.  Here we provide an overview of our combo box form control programming examples.



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.

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.


Our goal is to offer you information required to create efficient Access databases. At the same time we hope that you'll consider our services for your next project or you might hire us for hourly consulting to help you with programming tasks on your current project.

Access dropdown list, lookup lists, and combo boxes are all synonyms for basically the same GUI control.  The combo box control is used in nearly all programming languages include: HTML, Excel, Java, net, ASP, etc. 

Use the navigation links on the right side of this page to see each example in detail.  Below you will find excerpts from each of combo box examples.

Initially, a combo box control displays a single entry which is typically the default value, nothing, or the previously selected choice from the list.  The drop down feature is activated when the user clicks the down arrow which is located on the left or right side of the control.Combo Box Value

Combo boxes usually show several choices at one time with the selected or default choice highlighted in some manner.  All of our examples use Visual Basic, VBA, VB, VB script code.  We don't use macros.

These form controls normally provide two functions:

  • Establish a known/consistent list of values from which to choose during data entry.

  • Allow for query parameter selection and report filter control.

In these programming examples we refer to the following controls interchangeably in Microsoft Access:

  • Dropdown Box

  • List Box

  • Combo Box

  • Lookup Lists

  • Dropdown List Box

  • Value List

An Access combo box looks simple on a data entry screen.  However, these controls combine nearly all aspects of database programming including table design, Visual Basic, query design, and finally the user interface design.  They are probably the most complex (seemingly simple) of the Access database form controls.

Our developers have put together the following excerpts from our examples to show you a variety of Access combo box techniques.

Yes/no Drop Down List
The simplest dropdown list box - the yes/no field.  Create a fielCombo Box Yes/Nod (text) in your table with a field length of one character.  Create a validation rule that specifies in ("Y","N").

Table-based Access Combo Box
Lookup lists based on values stored in a table.  It is pretty simple to setup and provide you and your users with the flexibility toCombo Box Row Source add new list items as necessary and that is how 95% of MS Access users/developers setup a combo box. 

All/Any Choice List Box

Add choice to a table-based list using union query.  Start by setAdding All As A Combo Box Dropdown List Choiceting up a dropdown lookup list using table as the row source with ' All' added to the item list.  This All query setup is used to provide with user ability to choose a specific item in the list or select All records.
 

Lookup List-Correct Way
Lookup list table design & index pointers. Combo Box Bound Column The autonumber ID field makes the database compact, efficient, and reliable. 

Fill In Other Form Fields
Filling in a text field from a dropdown list:  Expanding uponCombo Box to Fill Form Fields a previous example, suppose that we have account numbers associated with each shipping method and that these account numbers (for whatever reason) can change over time. 

Best Way to Fill Form Field
A better way to fill text field from a multi-field combo box.

Dependent Combo Box List
Cascading combo boxes. Changing the controls source programmatically with a parameterized query for row source. 

Multiple Dropdown Lists from One Table
Combining many lookup tables into one table - advance table and query design

Speed Up Form Lists
Speed up slow drop down list box activation time - advanced VB Script

You can find more information on programming lookup lists on Microsoft's website.








A Blue Claw Database Design Article:

Why Choose Microsoft Access
 





Blue Claw Database Design Downloadable Tutorial:
Download Continuous Form Dependent Combo Box  





A Blue Claw Software Design Template:

Customer Relationship Management (CRM) Template
 

Contact Information

Copyright 2000-2017 Blue Claw Database Design

Microsoft Access 2007, Access 2010, MS Access 2013