Creating a nested, expanable and collapsable input design within MS Access. Like what exists in MS Project

Posted on 2011-10-11
Last Modified: 2012-06-27


I am wondering if it is possible to build an input form in MS Access that will mimic the behavior and functionality that exists in MS Project. I am referring to the way you can have nested tasks that can expand and collapse with the little plus sign and minus sign. Not asking you to explain exactly how to do it as a response to this question, I am wanting to know if it is possible and hoping you can point me to some examples on the web.

Thank you!
Question by:RiverWalk
    LVL 47

    Assisted Solution

    by:Dale Fye (Access MVP)
    Yes, you should look into the treeview and listview controls.

    Check out this explaination:

    The author walks through about a 7 step process to explain treeviews.
    LVL 75

    Accepted Solution


    Sounds like an application for a treeview control.

    Freeware Instant Treeview (Scroll down to bottom  of the page until you get to Access Tools)
    Comes with db that has jump start (Access db) example and an online tutorial. It's very cool.

    LVL 75

    Expert Comment

    by:DatabaseMX (Joe Anderson - Access MVP)
    Additional TreeView control resources:

    How to fill a Treeview control recursively in Access 2000

    Here are step by step Treeview instruction with source code and references


    Author Closing Comment

    Thank you both!
    LVL 47

    Expert Comment

    by:Dale Fye (Access MVP)
    Glad to help.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    The first two articles in this short series — Using a Criteria Form to Filter Records ( and Building a Custom Filter ( — discuss in some detail how a form can be…
    Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
    Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
    In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now