how to create a report with links to more detail

[dotolee]

i have a table that has a lot of fields on it. the user would like to be able to run a report by date. the initial results will show just a few fields... and then if the user clicks on a record, they want me to display another report with more info on it.
i'm not quite sure how to do this.
i'm using access 2000.
any suggestions would be appreciated. thanks.

 

[dhookom]

Reports are not interactive. You would need to use forms for drilldown.

Duane
Hook'D on Access
MS Access MVP

 

[TheAceMan1]

How are ya dotolee . . .

Agree with [blue]dhookom[/blue]. There are no events available to detect user intervention.

See Ya! . . . . . .

Be sure to see faq219-2884 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]