Search results

So, I was def copying in the code wrong. Thank you so much for your help!! You have been marvolouse!

Yes, I have. I opened it and it is currently up on my screen.

It doesn't hold true only when I try and change the Family from Finance to Admin Services. Is there any other advise that you can give me?

I'm a little confused on what you mean Bill. It works out fine when I choose "Administrative Services" on the first drop down, but the Sub Family is not changing when I choos "Finance". The end result would be: Choose a Family (Finance)> Choose a SubFamily (Accountant) > Choose a Skill Set...

So, what your saying is that I can not filter by Job Family to get the corresponding SubFamily to get the corresponding Skill Set with one table?

I have attached the DB that you requested. I also need the cboSubFamily to feed into the cboSkillSet. Thank you for your help!

Okay, now that I changed the Combo Box names, I am getting another error. After I select from cboJobFamily and try to choose from cboSubFamily the error is saying that it can not find my database "Could not find file C:\Users\Documents\me.mdb".

Bob, Okay, I have renamed the Combo Boxes: 11= JobFamily and 13=SubFamily. I am not able to upload a fake data base at the moment.

Bob, The Combo Boxes only have one feild in them. And when I put in your code, it gives me the same error and the same definition for the error.

Hello, I am trying to create a Cascading Combo Box for my Form in Access 2010. I ahve written the code: Private Sub Combo11_AfterUpdate() cboCombo13.RowSource = "Select TblAcc.SubFamily " & _ "FROM me.TblAcc " & _ "WHERE me.TblAcc.Family = '" &...