Dependent triple dropdown boxes

[danwoltrs]

Hi guys, I am making a new project now to help the accounting here in my small company - we basically have 4 accounts and I want to easily input what is going out and which account, category and sub-category.

I did some googling, and found that Indirect could work, but I would rather have three columns only, one column for account, one for category and one for sub-category - this already eliminates the Indirect method I found on google. Another method would be with Pivot tables, but the problem is some of the categories and sub-categories will have the same name...so that eliminates this as well I think.

Would anyone have any tips on how to do it? Here's an example of what it should look like.

In the end I will add a button that will copy all the values and add to another sheet, this I have done previously with the help of you guys - so basically I would only need help on the dropdown boxes showing only items that are dependent to their categories.

[dflak]

You are probably right that a non-vb solution won't work.

Here is a setup that uses VBA code to set filters on pivot tables and overlaying named ranges for cascading dropdown boxes.

http://www.utteraccess.com/wiki/inde...ists_%28VBA%29

[FDibbins]

Here an example of a 3-level dependent drop-down, it uses named ranges and INDIRECT. See if you can adapt it to suite

[danwoltrs]

You are probably right that a non-vb solution won't work.

Here is a setup that uses VBA code to set filters on pivot tables and overlaying named ranges for cascading dropdown boxes.

http://www.utteraccess.com/wiki/inde...ists_%28VBA%29

Thank you dflak!! This worked perfectly!!