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: 3749
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:

More topics

 

Populate combo box based on selection from another combo box

Preview
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

Preview
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

Preview
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

Preview
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)

Preview
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

Preview
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

Preview
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

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

Populate list box based on combo box selection

Preview
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?
 

Cascading Combo Boxes on continuos form

Preview
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