Results 1 to 3 of 3
  1. #1
    Join Date
    May 2002
    Thanked 0 Times in 0 Posts

    Drill into Data (Access 2000)

    Is there any way to develop drill down forms or sub forms of data? I have a large table- with 4 hierarchical levels. Level A would be a total of appropriate level B . Level B would be a total of appropriate Level C. Level C would be a total of all appropriate level D.

    I would like to be able to drill into a level A, and bring up all relevant Level B, and so on. Can someone help me think about this? I am thinking that I have to set up the table with Level A name, Level B name, Level C name.

    I would like to avoid multiple queries, as that can get messy.

    I think I just need a push in a direction.....

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: Drill into Data (Access 2000)

    You can use a series of combo boxes to successively limit a selection. See for example the following MSKB articles:
    ACC2000: How to Synchronize Two Combo Boxes on a Form
    ACC2000: How to Create Synchronized Combo Boxes
    There are also several threads in this forum; search for cascading combo. For example: <post#=132255>post 132255</post#>.

  3. #3
    Silver Lounger
    Join Date
    Jun 2001
    Niagara Falls, New York, USA
    Thanked 0 Times in 0 Posts

    Re: Drill into Data (Access 2000)

    <P ID="edit" class=small>(Edited by charlotte on 14-Jan-04 20:09. edited to activate link)</P>Check out the attached sample db from:

    Candace Tripp Cascading Combo Boxes Demo

    Hans added a 4th select table field for me a while back, woops I guess I could of searched for the post!



    PS: would like to see other solutions
    Attached Files Attached Files

Posting Permissions

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