Here is a great post on a handy trick I told some buddies at Microsoft.
http://blogs.msdn.com/access/archive/2008/01/14/easy-drill-through-with-macros.aspx

Here is a screen shot of one of the many places we use this technique in the inventory tracking system we use for managing the data behind CheckOutMyCards.com.

As a front-end development tool, Microsoft Access provides an incredible balance of power and rapid development that allows us to move quickly with changing demands. Microsoft SQL Server 2005 is currently our back-end database for both our in house inventory management system and our ASP.net web site.