Form with Expand/Collapse features

[Guest]

I'm trying to create a form (not a data access page) that shows a list of
records wich allows users to drill down and see or edit the detail of a
record.
The result I wanted is similar to this:
Account 2005 2006
- 1 - A&P 3.000 2.000
11 - Advert 1.500 1.500
12 - Promo 1.500 500
+ 2 - G&A 5.000 1.000

Is it possible to do this in a Access form?

 

[Albert D.Kallal]

You can consider using a treeview control, but it take code and a learning
curve to make such a control work (and, it is NOT native to ms-access).

On other hand, two sub-forms side by side often will give you the drill down
you need.

Take a look at the following screen shots of two sub-forms "side by
side"...it might give you some ideas....

http://www.members.shaw.ca/AlbertKallal/Articles/Grid.htm

 

[Guest]

Thanks for your help.
But I was thinking in something that allows users to expand the detail of
several records at the same time.

 

[Albert D.Kallal]

Likely, you are talking about something that works like the windows explore.

Do note that a "data" sheet view will show a "+" sign, and for each record
that you click on the +, you do see the detail records.

If you want to go the activeX way..and use the same control that you see
when you browse files on your computer (and the + shows more files), then
you can use what is called a treeview control.


ACC2000: How To Fill a TreeView Control Recursively
http://support.microsoft.com/?id=209891

ACC2000: Example Using TreeView Control Drag-and-Drop Capabilities
http://support.microsoft.com/?id=209898

ACC2000: How to Migrate from Data Outline Control to TreeView Control
http://support.microsoft.com/?id=209927