Filtering data on form through multiple combo boxes

[Draconius]

I have a Table (Mail_Type) that has two columns ("SLA" and "Doc_Type"). I am trying to create a form when a certain SLA is selected (1st combo box), then only certain Doc_types will show under the 2nd combo box. I followed this aid (http://www.datapigtechnologies.com/f...combobox1.html and http://www.datapigtechnologies.com/f...combobox2.html), however the 2nd combobox is completely empty and showing no results. I attached multiple screen shots below to try and show everything...I am an access novice so I can't figure out all the steps.

My Table that shows Name, and column names


What my form would look like:


My first combo box code that groups the SLA's into their common name (This works perfectly and shows correct when I run it)


My second Combo Box code shows...this doesn't work. It won't show anything when I try to expand it when using the form, and when I try to run it, it comes up with a blank table with only the SLA column (which is also blank)

[pbaldy]

First, make sure you are requerying the second combo in the after update event of the first. It appears you have an "apples and oranges" comparison going on. The criteria in the second combo is on the doc type field. I'd expect it on the SLA field, and I doubt you need the Total row activated.

[Draconius]

hi pbaldy,

Thanks for the quick response. The requery right now is on the bottom of my list, because when I run the row source on the second combo box (3rd picture) it comes up blank. That is my first need. Could you further explain your "apples and oranges" reference? I set up my table the same way the video that I linked shows, so it should have just been a differentiation to his names to my names.

Also, the criteria in the video showed that it should be on the 2nd combo box and to reference the 2nd results and not from the first...(does that make sense?)

[pbaldy]

The second combo won't work without the requery of the first, so it needs to be in there. You are choosing an SLA in the first combo, so your second combo should say, in English, "give me the doc types with the SLA matching the first combo". What you have is "give me the SLA's with a doc type matching the first combo", the opposite of what you want. Maybe this will be easier to understand?

Baldy-Cascading Combos

[Draconius]

Thanks pbaldy! Seeing your sheet helped out a lot. The data fields now are selected!

[pbaldy]

Excellent! Happy to help.