Populate one combo box based on the selection of another combo box
Thank you for taking the time to report an issue.
What's wrong... Please write below.
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
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.
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..
depending on what value is selected in the first combo box will dictate what values are shown in the next 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.
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
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.
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