Results 1 to 6 of 6

Limit dropdown list based on selection from another list

Threaded View

  1. #1
    Registered User
    Join Date
    04-04-2014
    Location
    Oregon
    MS-Off Ver
    MS 365 Enterprise
    Posts
    29

    Limit dropdown list based on selection from another list

    Let me preface my question with the fact that my Access database knowledge is very limited. The database I'm using is an exceedingly simple set-up where I enter the Date, Hours, Type, SubCat, and a Memo into a table to record my daily time. It's all in one table and I've used combo boxes to create drop down lists for the Type and SubCat. See attached image to get a visual on what I'm referring to.

    A new year brings new categories and a need to change this from a two-level structure to a three-level structure. Previously using just "Type" and "SubCat", I now need to add a level between the two labeled "Category" (which I have already done). The functionaility that I didn't previously have (or need) is the ability to limit the list selection based on what is previously selected. For example, if under "Category" I were to select PIT, then I would only want Help Desk, Solutions, DNN & TTCs to be my dropdown options under SubCategory. I would like to customize each Category with it's own subcategory listing. (Please note that it is possible that a Subcategory may be an option under more than one Category.) The attached Excel document is my "map" as to what options should be available once a prior selection is made. I hope that this is making sense!

    Thanks for any help that can be provided. My hope is that I can just change a few settings or make some minor alterations to my existing database to gain this functionality.
    Attached Images Attached Images
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Populating information based on selection from dropdown list
    By kearbear in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-10-2013, 11:16 PM
  2. Replies: 6
    Last Post: 05-31-2013, 11:17 AM
  3. [SOLVED] Calculation Based On Dropdown list Selection Excel
    By rnohoy in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-26-2013, 06:16 AM
  4. Cull dropdown list options based on selection in another dropdown
    By Kiffar in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-20-2012, 01:53 AM
  5. Dynamic dropdown list selection based on combo box
    By Lifeseeker in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-10-2012, 10:55 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1