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.
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 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 field
(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 to
add new list items as necessary and that is how 95% of MS Access
users/developers setup a combo box.

Add choice to a table-based list using union query. Start by setting
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.

Fill In
Other Form Fields
Filling in a text field from a dropdown list: Expanding upon
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.