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: 3805
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...

 

Combo Box, Text Box Based on Selection from Other Combo Box

Combo Box, Text Box Based on Selection from Other Combo Box Icon
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
 

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..
 

combo box values dependent on selection another combo box

combo box values dependent on selection another combo box Icon
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
 

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
 

3rd Combo Box Cascade Issues

3rd Combo Box Cascade Issues Icon
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
 

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.
 

Limit combo box 2 values based off of combo box 1 selection

Limit combo box 2 values based off of combo box 1 selection Icon
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