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

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:

Related Topics

Populate combo box based on selection from another combo box
I've been trying to find a way to filter one combo box based on another combo box selection. My problem lies herein. The first combo box is a list of import dates. I need the second combo box to populate with the Vendor names that were imported on the date that has been selected from the first combo box. Based on the selection of the second combo box I then need my form to populate the records that are associated with the two selections. I would like to do this using VBA.


Combo Box, Text Box Based on Selection from Other Combo Box
I have a form where I want a combo box to populate based on the selection in another combo box. I also want a text box to populate based upon the selection in a combo box.

For the combo box - combo box situation: if my user chooses "Yes" in combo box 1, I want combo box 2 to automatically populate with "N/A". If they choose anything else in combo box 1 ("No" or "Unknown" are other options) I want combo box 2 to be left alone for the user to populate themselves ("Yes", "No", "Unknown" are other options they can choose from).

For the text box - combo box situation: if my user chooses "water" or " food" from combo box A, I want text box A to automatically populate with "N/A". If they choose "Other" from combo box A, I want text box A left alone so that the user can type themselves.

Any suggestions? This is something I have been trying to figure out for ages. it is the last change I need to make before this db goes live (finally


Combo Box, Text Box Based on Selection from Other Combo Box
I have a form where I want a combo box to populate based on the selection in another combo box. I also want a text box to populate based upon the selection in a combo box.

For the combo box - combo box situation: if my user chooses "Yes" in combo box 1, I want combo box 2 to automatically populate with "N/A". If they choose anything else in combo box 1 ("No"or "Unknown" are other options) I want combo box 2 to be left alone for the user to populate themselves ("Yes", "No", "Unknown" are other options they can choose from).

For the text box - combo box situation: if my user chooses "water" or " food" from combo box A, I want text box A to automatically populate with "N/A". If they choose "Other" from combo boxA, I want text box A left alone so that the user can type themselves.

This is something I have been trying to figure out for ages. it is the last change I need to make before this db goes live (finally).


Populate on combo box based on another
I have two combo boxes in a form, and I'm trying to populate one based on the selection of another. I tried using someting like [Forms]![Form name]![Combo Box name] in the criteria of the query for the row source of the secondary combo box, but it doesn't seem to be working. What do I do?


Populate a combo box based on selection in another combo box (Access 2010)
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
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..


combo box values dependent on selection another combo box
what I want to do is populate a combo box whose values are linked to a specific value in another combo box.

depending on what value is selected in the first combo box will dictate what values are shown in the next combo box


Populate a field based on combobox selection
I would like to populate a (another) table field based on user combo box selections.

I would like a combo box with selections A, B, C, D, E, etc.

If combo box A is selected, it would populate with the numeral 1; if B were selected, it would populate with the numeral 2; if C were selected, it would populate with the numeral 3; etc.

So, we would have a combo box in the form, but it would not populate a table field with the combo box selections, but with values driven by the combo box selections.


Cascading Combo Boxes on continuos form
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


Populate list box based on combo box selection
I am trying to populate a list box based on selected entries from a combo box. The combo box data comes from a different table from the table the form is based on. I have the elements already on my form, but I don't know how to get the list box populated. I have a lot of experience with Excel VBA but this isn't helping me here. What I want to do is, have a user select an item from the drop down box and after it's selected, have that item transfer to the list box. What is the best approach for doing this, using VBA or the expression builder?


How to limit values in a list box based on selection from a combo box?
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.


3rd Combo Box Cascade Issues
I currently have 2 combo boxes accurately cascading :

a. Combo Box 2 options depend on the selection of Combo Box 1

I want to have a 3rd combo box dependent on the selection of Combo Box 2.

Currently seeing blank options in my form though a selection in Combo Box 2 has been chosen. I have tried to look at some previous threads on this but my problem still hasn't been resolved.

Side note: I am currently using a query for reference on combo boxes which represents the entire table of information that I need. I had to do this because when I attempted to create acombo box 3, many error messages of different types popped up and ruined the cascade I programmed at the beginning.


Display selected value of Combo Box
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


3rd Combo Box Cascade Issues
I currently have 2 combo boxes accurately cascading :

a. Combo Box 2 options depend on the selection of Combo Box 1

I want to have a 3rd combo box dependent on the selection of Combo Box 2.

Currently seeing blank options in my form though a selection in Combo Box 2 has been chosen. I have tried to look at some previous threads on this but my problem still hasn't been resolved.

Side note: I am currently using a query for reference on all combo boxes which represents the entire table of information that I need. I had to do this because when I attempted to create a combo box 3, many error messages of different types popped up and ruined the cascade I programmed at the beginning.

A little info on me: novice in VBA. Hopefully someone can give me information that will contain little to no coding


Combo box IF
I'm looking for a template for a VBA macro that looks at a combo box selection, checks the value, and references a table to populate a text box (on same form as combo box) based on the input.

For now I'm just trying to wrap my head around something simple. Learning VBA though VBA Express at the moment.


Default Value for Cascading Combo Box
I have 2 combo boxes, one of which is populated by the result of the other. In some cases, there is only one possible selection in the combo box dropdown, based on the selections.

I would like to have the combobox automatically show the single selection, if there is only one possible option. However, if the result of the first selection allows for more than one option in the second combo box, I would like it to remain balnk and let the user choose the result


Combo box remains unbound
In a form with a combo box on, I populate the combo box with data from another table. My problem is I dont want the combo box to unbound as it is at the moment. I don't want the data selection to persist from one record to the next.


Populate combo box based on previous combo box selection
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.


Limit combo box 2 values based off of combo box 1 selection
I have a form that contains 2 combo boxes - Source Class (combo box 1) and Sub Class (combo box 2).

I am trying to figure out how to limit the Sub Class values based off of what is selected in combo box # 1. As it stands now each combo box runs off of its own query - both queries relate to one table.

Can someone point out where I am going wrong? Or maybe I am setting the queries/table up the wrong way


Update Combo box list from selection in combo box
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