Combo box value depends on the selection of another combo box in Access

[matthewmcfarland]

This was tricky to figure out. The Microsoft help website talks about "drilling down" through the structure of the database. The tricky part was trying to figure out what table was being referenced in the combo boxes and the relationship between those tables as far as parent and child. The parent, or combo box 1, can have a one-to-many relationship with the child. The structure of the tables is very important in trying to get this to work. Thanks for sharing austin72406. You really get this stuff!

[alanstevens]

I wish you would have talked about the query that you made ahead of time that was the row source for your second combo box

[ontracklifetools]

Great video. I've ran into a problem though and I've looked at it from every angle and can't seem to figure it out.

I have 4 levels of cascading combo boxes. When I select a value for the first box, the second box filters the available options perfectly and I'm able to select one just fine. When I get to the next, third combo box however, I immediately get the "This expression is typed incorrectly or it is too complex..." error and there are no values available to select from. Same story for the 4th one.

The queries for each of the 4 combo boxes reference are virtually exactly equivalent to each other as well as the criteria code. I just can't figure out why the concept works fine for the second box but won't work for the third or fourth when they, again, are virtually exactly the same.

I have the right VBA to requery the next box as each box is filled, each row source is pointing to the right place, the boxes, queries, and tables are all named and referenced correctly, everything seems to be right, but it won't still work.


I'm completely stuck. Anyone?

[ganesh]

I am from rural area but trying to do automate programs through access. And from lot of days I am searching this thing after all at last I got it.

[pruthvirajsuryawanshi]

Sirji, you understand the way O really is very good .. It gives us a lot of knowledge…
Sir, a search box from which we search and create a check box (such as a class) and a check box button can be obtained by clicking on it (such as its Aadhaar number, its mother's name…). ...

[aakburns]

Thank you. I’ve been trying to do this for... days. I’ve been doing it backwards.

[haninokasha]

Hi ! Any Idea what can I do if I added A third Combo box that depends on the Value of the filtered second combo ?

[MsrRycerski]

Austin
One more time very big thanks for your tutorial - its very useful.

[hiraiftikhar]

You videos are great. I have learned alot from them :) thank you for being so helpful

[พิชญะชัยชนะ-คต]

Thanks for your clip, this helps me a lot

[zlajatube]

thank you but how to make default value for second combobox and still be able to see whole list depending on first combo...

[michelef.]

Thank you for you explanation, it was really clear!!!. I have only one question, I did it right, But I would like to have the second combo box to become empty if I change the first combo box. In your example it happens, but in mine it doesn't, can you help me?

[jayakumarm]

Thank you! That was easy and worked well.

[mdhaziq]

Hello,
for the 2nd combo box the query for your example uses [Form]![Customer]![Combo219]
I couldnt get the drop down when I type it out. When I enter they prompt me that it is invalid.
Why is that so?

[deweywsu]

Thank you so much for posting this. It really helped me out!

[walterongwongsakul]

How do you get the value in Combo Box 2 (Select Customer Name) to reset back to "blank" every time after you update the customer type?
Thank you for the tutorial ... very easy and powerful....I am working on a task similar to the idea presented here though everything works perfectly fine ONLY the re-query function doesn't reset the value back to "null" but rather keep the previous value which is very confusing to the user if they have to do multiple orders. Thanks in advance!

[evatsompou]

Hello! I have a combo box for Contracts and another combo box that displays the Supplier based on the selected contract. All these created under the instructions of the video. The problem is that whichever Contract I choose from the first combo box, I always get only one of my two saved suppliers (and that is not the corresponding supplier!). Is there something in the property sheet that needs to be changed?

[chhansambath]

Hi! How could we use 4or5 combobox independence from combobox1to combobox5 and switch from 5 independence to1combobox. I mean can search data like state, city, commune to provinces and from provinces state ?

[abdurrehman]

when i was creating second combo box "Create Box Wizard" at first step "Third Option is missing in my Access 2010 & 2013 too.
where this line is written "Find a record on my form based on the value I selected in my combo box". ??? so how can resolve it ??? any help ??

[swapnilthakur]

Hi,
How should we auto populate the all values in diffrent text box depending upon the selection of the one dropdown value??

Means, Suppose we select the specific value from dropdown and once we select the value from dropdown then text box automatically fetch and fill the data.
i want this in ADF view criteria