Form with Expand/Collapse features

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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
 
Thanks for your help.
But I was thinking in something that allows users to expand the detail of
several records at the same time.
 
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
 
Back
Top