Topics Search

Populate one combo box based on the selection of another combo box

Populate one combo box based on the selection of another combo box
Views: 3806
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...
Sponsored Links:

Similar posts...

 

Populate a combo box based on selection in another combo box (Access 2010)

Populate a combo box based on selection in another combo box (Access 2010) Icon
I'm have quite a difficult time getting a form in Access 2010 to perform the way I would like it to. I have multiple tables that I've created, and a query that contains the data from the various tables.

I then ran the form wizard to select the data from the query that I wanted to populate in my form and I've added 2 combo boxes.

What I want to do:
1. I want users to be able to select a category in combo box #1 (example: "Bag")
2. I want users to be able to select a detail in combo box #2 based on the category they selected in combo box #1 (example: Combo box #1, "bag" would populate the followingselections for combo box #2: "sandwich" and "tool")
3. I want users to then receive a list of suppliers that provide the product they have selected, either "Bag: Sandwich" or "Bag: Tool"

I have combo box #1 populating a list of categories already. However, I am not able to get combo box #2 to provide choices based on the selection chosen for combo box #1.

Preferably, a step-by-step instruction of what I need to do to make these work properly.
 

Access Form Text Box Entry depending on Combo Box selection

Access Form Text Box Entry depending on Combo Box selection Icon
What I would like to do is have a form field (text box) auto populate a value depending on the selection of a combo box within the same form.

Example: Combo Box Selection is "Prospect " and Text Box value would auto populate to "Opportunity"
or: Combo Box Selection is "Client " and Text Box value would auto populate to "Clients"

The Combo Box is named "Contact_Type" and the Text Box is named "Category"

Basically I'm looking for an Expression or VBA Code that can do this..
 

Cascading Combo Boxes on continuos form

Cascading Combo Boxes on continuos form Icon
I have a continuous form that has 2 combo boxes, I choose a selection in the first combo box and the 2nd combo box offers me options related to my selection in the first one. This works great, until I move to the next line, and it requeries the 2nd combo box based off of my new selection and my previous entry is changed to the new selection? not sure how to requery the 2nd combo box on a continuous form
 

How to limit values in a list box based on selection from a combo box?

How to limit values in a list box based on selection from a combo box? Icon
I'm trying to create a form (MS Access 2003) that currently has 2 items in it: a combo box and a list box. I'd like to be able to make a selection from the combo box and have the list box display a filtered version of the data based on the selection from the combo box.

For example, the combo box has a list of different projects, (a, b, c, and d) and the list box has a list of ALL of the reports associated with all of the projects. I'd like to be able to select project "a" from the combo box and get ONLY the reports associated with project "a" displayed in the list box.
 

Display selected value of Combo Box

Display selected value of Combo Box Icon
I have a combo box the elements of which are one field from a table in the database. Under Property Sheet for the combo box, I have Record Source set to blank and Recordset Type set to Dynaset. When I click on the arrow at the end of the combo box, I get the proper list of choices, but when I select one of them, the field of the combo box remains blank. Of course, I want the combo box to display the selection that I just clicked on, and then to code an action based on the selection. I have been examining all of the properties of the Property Sheet and have experimented with some, but still a blank in the combo box
 

Populate combo box based on previous combo box selection

Populate combo box based on previous combo box selection Icon
I am trying to populate a second combobox which depends on selection in first combobox. To this end I have created four tables:

categoryType – This table has the data for the first combo box and contains three records, Expenses, Income and Refunds

categoryRef – This table contains about 10 records and the data should be displayed when Refunds is selected in the first combo box

categoryInc - This table contains about 15 records and the data should be displayed when Income is selected in the first combo box

categoryExp - This table contains about 20 records and the data should be displayed when Expenses is selected in the first combo box

Is the above the best way to achieve what I am trying to do? Are there any alternatives?
I need this to be fairly low maintenance as there may be a need to add/edit/delete records from any of the tables from time to time.
 

Update Combo box list from selection in combo box

Update Combo box list from selection in combo box Icon
I am trying to create a form that has 2 combo boxes and when I make a selection in one Combo box I want that one to limit what I can chose from in the second one. My example would be this.

Combo Box 1: Type one
Combo Box 2: Sub type one
Sub type two
Sub Type Three
or if

Combo Box 1: Type Two, then
Combo Box 2: Sub type Three
Sub type four
 

Synchronize Two Combo Boxes on a Form

Synchronize Two Combo Boxes on a Form Icon
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.
 

Unable to update combo box using list box selection - error 2115

Unable to update combo box using list box selection - error 2115 Icon
I am trying to set the value of a combo box based on the selection of a list box. I have created a very simple generic form to try to achieve this goal, but without success. The form has a list box bound to a query, a button, and a combo box bound to another query.

The queries for the list box and the combo box are independent. I can set the value of the combo box when the form loads (sub Form_Load) and when I click on the button (sub Command2_Click), but when I make a selection in the list box (sub List5_AfterUpdate) I get Runtime error 2115: The Macro offunction set to the BeforeUpdate or ValidationRule property for this field is preventing MS Access from saving the date in the field.
 

Generate Report Based on Form Combo Box

Generate Report Based on Form Combo Box Icon
I have a report that has a Record Source set to a Query. In the Query I have the criteria of the desired field set to [Forms]![ROUTE_NUM_FORM]![Combo0]

I expected that each time I opened the report, I would see the combo box on the form, make my selection from the combo box and then the report would filter based on the combo box selection. Should this work?