Drill Down Objects in Access

  • Thread starter Thread starter ChuckW
  • Start date Start date
C

ChuckW

Hello,

Are there any drill down objects in MS Access? I want to
create some reports or forms of weekly sales. There
would be line items for Week Sales. It would be nice to
have a link that would then drill down to show all of the
products and services for the week that were sold during
the week. Is there an object in Access that does this?

Thanks,

Chuck W
 
nick said:
I thought access reports were read-only
Click to expand...

They are, but what ChuckW wants to do can be done in a Form. There are no
"drill-down objects" or "drill-down controls" but code can be added to
various events (e.g., the Click event, or the Double-Click event) to open
another Form with details. In fact, if you use a Combo Box to select, you
can put the code in that Combo's Click or Double-Click event.

Larry Linson
Microsoft Access MVP
 
Back
Top