DrillDown

[Rich1968]

I want to be able to drildown thru my data say in a report that totals sales figures for the month to the basic data behind the totals in a report or form.

As suggestions?

Rich1968

 

[Pat Hartman]

Access reports are not "live" so they cannot support drill-down. You can create a drill-down if you use a form.

 

[Rich1968]

Drilldown

Ok Great any suggestions on the best way to accomplish this?

 

[Pat Hartman]

Use the double-click event of a control to open a form with more detail. Use the where argument of the OpenForm Method to syncronize the forms. You can use the openArgs argument to pass the name of the form that opened the current one. That way, you can hide a form after you open a more detailled form and pass the hidden form name. When going in the reverse direction, you should close the detail form rather than hiding it.