M
Mark McCauley
I am a novice user of Access 2000.
I have created a query that creates a list of records. Each record includes
an associated field Root, Level1, Level2, and Level3. The record may,
starting with the Root, have all four fields populated with data or the
subsequent fields may be empty or blank. I also have a report for that
query.
Question: Is it possible to create a form that displays each record grouped
under its level in a collapsible tree structure that will allow a user to
select the records to be included in the report by clicking on a check box
displayed next to the root, each "branch" (Level1, Level2, Level3), and each
record (and any combination thereof)? For example, by clicking on Level2 all
records "in" Level2 would be on the report, as well as any other checked
records or level(s).
If this is possible, does it require complex coding or is there a template
or example somewhere that I could use to create this form?
TIA
I have created a query that creates a list of records. Each record includes
an associated field Root, Level1, Level2, and Level3. The record may,
starting with the Root, have all four fields populated with data or the
subsequent fields may be empty or blank. I also have a report for that
query.
Question: Is it possible to create a form that displays each record grouped
under its level in a collapsible tree structure that will allow a user to
select the records to be included in the report by clicking on a check box
displayed next to the root, each "branch" (Level1, Level2, Level3), and each
record (and any combination thereof)? For example, by clicking on Level2 all
records "in" Level2 would be on the report, as well as any other checked
records or level(s).
If this is possible, does it require complex coding or is there a template
or example somewhere that I could use to create this form?
TIA