Enable users to find a record by selecting a value from a list
When you design a form in Access, you can create a list box (list box: A control that provides a list of choices. A list box consists of a list and an optional label.) or a combo box (combo box: A control used on a form that provides the combined functionality of a list box and a text box. You can type a value in a combo box, or you can click the control to display a list and then select an item from that list.) that can be used to find a record when a value is selected from the list. This makes it easier for users to quickly find existing records without having to type a value into the Find dialog box.

---

Populate one combo box based on the selection of another combo box
In Access 2003/XP/2000/97, I have a combo box that displays values based on the selection of another combo box. My problem is that when I make a different selection in the first combo box, the text in the second combo box does not change. Although the drop-down items are correctly changed in the second combo box. I have tried to requery but it doesn't work! Any suggestions?

---

Synchronize Two Combo Boxes on a Form
This topic illustrates how to synchronize two combo boxes so that when you select an item in the first combo box, the selection limits the choices in the second combo box. For example, you may want the products displayed in a combo box to be limited to the category selected in another combo box. Learn how to limit the choices in a combo box when selecting an item in another combo box.

---

Leaving a combo box blank
I have a form which runs a query based on a date selection from a combo box. I need to have an option whereby if you leave the combo box blank all records are selected. Is there a way to do this?

---

Refresh Dependant ComboBox Contents
There are instances of more than one combo box on a Form and it is likely that the contents of one combo box depends on the values of another one. In such situations limiting the contents of the second combo box with the data related to the current item selected on the first combo box is more appropriate, rather than displaying all of them always. The User can then select the item that he wants from a limited list instead of scrolling through a lengthy list to find the required one.

---

Filter records based on a combo box selection
I'm using Access 2003/XP/2000/97 and I need to figure out how to display the record details based on a combo box selection. For example, when I select a CustomerID in a combo box, how do I get the related customer name and address information to appear?

---

How to: Add "(All)" to a Combo Box or List Box
When you use a list box or combo box to enter selection criteria, you might want to be able to specify all records. Learn how to add an (All) entry at the top of a combo box.

---

Synchronizing Combo Boxes on Forms in Access 2007
When you build custom Microsoft Office Access 2007 applications, there are often situations where it is useful to synchronize two combination boxes (combo boxes) on an Access 2007 form so that when you select an item in the first combo box, that selection limits the choices in the second combo box. For example, it might be necessary to limit the products that are displayed in a combo box based on the category that is selected in another combo box. The Access 2007 combo box control generates the AfterUpdate event when an item in the combo box is selected. This article illustrates how to use the combo box AfterUpdate event to synchronize two combo boxes on an Access 2007 form.

---

Display only unique values in a combo box
When I try to build a combo box in an Access form, I get several repetitions of the same city displaying in the combo box. How can I design the combo box so that only unique cities appear?

---

Forms, Combo box based on another combo box
I have a combo box on a form which picks up a company, its address, phone etc. The same company can go into multiple records on the form. What my problem is that there are several contact people for each company and what I would like to know is if there is any way I can select the company for a particular record and then be able to select one contact out of the several that belong to the company. I have been to the Microsoft site and have looked at what they have which are 2 combo boxes based on 2 tables but when I try to make mine work I'm not having much success. I'm not sure whether I'm not working out the code correctly.

---

Combo box based on another combo box
I have a combo box on a form which picks up a company, its address, phone etc. The same company can go into multiple records on the form. What my problem is that there are several contact people for each company and what I would like to know is if there is any way I can select the company for a particular record and then be able to select one contact out of the several that belong to the company. I have been to the Microsoft site and have looked at what they have which are 2 combo boxes based on 2 tables but when I try to make mine work I'm not having much success. I'm not sure whether I'm not working out the code correctly. My Access skills are self-taught - I have no programming skills.

---

SubForm-2nd Subform Combo box Question
I have a combo box on a sub form. Based on the choice, I want another combo box on the sub-sub form to have a selected choice. I've tried to have the choice change the Row Source on the 2nd combo box but I've been unsuccessful. Both of the combo boxes are bound, so cascading them didn't work.

---

Combo Box Basics in Access 2003/XP/2000/97 (page 1 of 15)
A combo box is a drop-down list of values that the user can select from. Below is a combo box that has been set up to display a list of categories.

---

Using A Combo Box To Find A Record
In this tutorial you will learn how to Use A Combo Box To Find A Record.

---

Create an Access 2007 Combo Box
A combo box in Access 2007 provides a way of selecting a value from a list. This is quicker than remembering which value to type and ensures that the entered value is valid. A combo box is a compact method of presenting a list of choices and allows you to enter a value that is not in the list. Here's how to add a combo box in Access 2007.

---

Create a list of choices by using a list box or combo box
When entering data on forms, it is often quicker and easier to select a value from a list than to remember a value to type. A list of choices also helps ensure that the value that's entered in a field is appropriate. A list control can connect to existing data, or it can display fixed values that you enter when you create the control. This article describes the list controls that are available in Microsoft Office Access 2007, and shows you how to create and customize them. What do you want to do? * Learn about the types of list controls * Create a list box or a combo box by using a wizard * Create a list box or a combo box by adding a Lookup field to a form * Create a list box or a combo box without using a wizard * Edit a value list while a form is open in Form view * Customize a list box or a combo box

---

Combo Box Controls
A combo box is list of values from which the user can select a single value. Not only does this save typing, it adds another means of enforcing referential integrity since the user can only pick values in the combo box.

---

Microsoft Access Forms and Combo Boxes
MS Access is a very versatile data handling software. The Microsoft Access Combo box is one of the many features provided which generate elegant user data entry interfaces. A combo box is a data capture control just like a text box. It has a drop down list of predefined values. The user can click on any of these values to populate the text box. Alternatively, data can be typed into a combo box too.

---

How to Create Synchronized Combo Boxes
This article shows you how to create a combo box that is filtered to list only those items that are related to an item that you selected in a previous combo box.

---

Limit or change the items displayed in a combo box
You can limit the items that are listed in a combo box based on what is selected or displayed in another control, such as a text box or even another combo box.

---

Searching Records using a Microsoft Access List Box
In this article, we demonstrate how we can use a list box to pass criteria through to a search, allowing us to open a form (in this case) and return a specified result. This is similar to using a combo box to perform the same action.

---

Refresh the values in a combo box
I've created a combo box that is populated by a code table. After I add a new value to the code table it doesn't appear in the combo box list. How do I refresh the values in a combo box?

---

Populate underlying table when new entries are keyed into combo box
I have a form that is bound to a table. I have created a combo box on this form that obtains its values from a field that resides in a different table from the one that the form is bound to. When I enter values in this combo box I want those values written back to the associated field. How do I setup the combo box so that entries in the combo box are written back to the field in the table it came from?

---

Limit values in a combo box
I've created a combo box. I'd like to populate the combo box based on a query and then limit the user to only enter a value that is in the list. I don't want the user to be able to enter any values that I do not populate in the combo box. Is there a way to do this?

---

Display column headings in a combo box
On an Access 2003/XP/2000/97 form, I've created a combo box whose values are populated by a query. I want to see the column headings so that I can differentiate between the various columns. How do I display the column headings in a combo box?

---

Synchronize Microsoft Access Combo Boxes
The following article describes how to synchronize two Microsoft Access combo boxes so that when you select an item in the first combo box, the selection limits the choices in the second combo box.

---

How to: Add a Value to a Bound Combo Box
Combo boxes are commonly used to display a list of values in a table or query. Learn how to add a use the NotInList event to add a new value to a bound combo box.

---

Populate a combo box with a list of values (not from a query)
I've created a combo box in Access 2003/XP/2000/97. I don't want to populate the combo box with an SQL query. Instead I want to add my own values. How do I populate a combo box with a list of values that are not generated from an SQL query?

---

Use the Find and Replace dialog box to change data
This topic explains how to use the Find and Replace dialog box to find and optionally replace data in an Access database. * Learn about using the Find and Replace dialog box * Find and replace data in a table * Find and replace data in a form * Find data in a query result set * Find wildcard characters * Examples of wildcards in use * Find quotation marks and null or blank values * Find and Replace dialog box control reference

---

FindNext Macro Action
You can use the FindNext action to find the next record that meets the criteria specified by the previous FindRecord action or the value in the Find and Replace dialog box (on the Home tab, click Find). You can use the FindNext action to search repeatedly for records. For example, you can move successively through all the records for a specific customer.

---

Combo Box Function in Forms
I am trying to display records in my subform (projects) using my combobox in my main form (clients) so that I do not have to scroll through my whole list of clients to get to a certain project record. However, when I use the combo to select a client, it just changes the cient - it does not go to the project(s) that relate to that client. Can you help me? Does this need a filter function to complete this task or something else?

---

Base Combo Box on Parameter Query to Filter Values
This article shows you how to filter values that appear in a combo box by basing the combo box on a parameter query.

---

Combo Boxes 1 (create basic combo box)
In this tutorial part-1 you will learn create basic combo box. (video tutorial)

---

Display field names in a combo box
I've created a combo box and I want to list the field names from a table or query. How can I do this without having to write elaborate code?

---

Combo-Box Column Values
Command Buttons are the most commonly used control on a Form. We have seen them in action in different ways and with different designs. Next in line is the most preferred and familiar control on Forms; the Combo-Box Control. This can be created not only on Forms but also on Tables as well.

---

Bind combo box to primary key but display a description field
I've set up a table that contains an autonumber field as the primary key and a description field. I want to be able to create a combo box that displays the description, but stores the primary key. How do I set up the combo box?

---

Using the Combo Box's Not In List event with multiple fields
We usually provide database users with Combo Box controls in a Form to limit the data that the user may select from. However, if the data isn't already present in the underlying database table, then you must provide the user with an easy way to add new items to the list. We saw this approach in a previous tutorial on How to use the Microsoft Access Not In List event of a combo box This previous tutorial is fine when adding a single field value to the underlying database table. What happens if the combo box contains multiple fields that need values adding to the table?

---

cbo box to subform + add records
I want to have a combo box select a record and display that record's information in the subform. This can be based directly on the table, or from a qry (I already have a query because I use an expression for a concatenated lname & fname & dob elsewhere). I've accomplished this by having the cboSelectedPatient on the main form, and appropriately linking the master & child link properties, and requerying "On Update". ...

---

Adding (All) Options to Combo Boxes or List Boxes in Access 2007
Learn how to add an (All) entry to the list of items displayed in a list box or combo box in Access 2007. Developers frequently use list boxes and combo boxes in Microsoft Office Access 2007 forms to let users specify selection criteria. Adding an (All) option to the list of items can be helpful in scenarios when users might want to select all the items in the list. This Office Visual How To illustrates how to add an (All) entry to the list of items displayed in a list box or combo box in Access 2007.

---

Find the records with the top or bottom values in a group or field
This article explains how to use a top value query to find the highest or lowest values in a set of records. You use top value queries to answer a variety of business questions, such as which products sell well and which do not. What do you want to do? * Understand top value queries * Find the records that contain top or bottom values * Find the top or bottom values for records in categories or groups * Find the records that contain top and bottom values

---