Drill Down Form Designer
Create a form that lets you drill down to the data you want to see by just clicking on a field in the form.  Give your users the ability to quickly sort and find information by just clicking with the mouse.   Your customization of this form might become the most used form in most of your applications.

Databases are very powerful tools used to find, sort, reformat, manage, send and do all kinds of other things with data on your computer.  The more data you have the more you need a database to access it quickly, but that makes the data harder to find.  So, we built a tool that lets a user “drill down” to data very quickly in a form by just clicking on a field that has the type of data that he wants to find.  Some call a similar functionality “Query by Example” though in this case it might be more accurately called “Query by Selection.”  We have just gotten used to calling it “QB” for short.

This example demonstrates a form that lets you drill down to the data you want to see by just clicking on a field in the form.  This example is built for/with Access 2000.  It requires that you have a moderate level of experience with Access 2000 creating Access Applications and the Access VB editor.

How it Works
The drill down form allows a user to quickly find or drill down to specific data just by making a series of mouse selections on data in fields on a form.  Let’s say you have a customer database with thousands of records from customers all over the country and you need to find every one born in June in Georgia with the last name of Smith to do a promotion.  Quick how do you find that data?  With this tool you can find it with three clicks of your mouse!  Take this technology and make it yours to create very powerful forms for your user applications.

The Drill Down form allows you to quickly sort down to information that you want to see.  If you double click on Douglass in the county column the form will filter and sort and just show you every client that lives in Douglass county.  If you subsequently double click on Douglass the form will un-apply the filter and reshow all counties.  It is a really fast way to drill down to specific data and adds a powerful form to any application that your users will love to use

Installation 
Download the example zip file to your hard drive and then unzip it.  You can run the example file in any location as it is all self contained. 

Prerequisites
This example is built for/with Access 2000.  It requires that you have a moderate level of experience with creating Access Applications and the Access VB editor.  You will need to have Access 2000 or later licensed on your computer.
     
Benefits

• Fast and easy to use Drill Down tool for your apps
• Inexpensive way to add a powerful search tool to your apps
• Easily customizable for other applications
• Fully documented
• Database example with all code needed that you can use or edit for your need

Please enter the following simple information to receive the Drill Down Designer Tool

What's Included
You will receive in electronic form an example database with a working model and all the coding and detailed manual describing how to build the form in your applications.  You will find that this tool will be one of the most popular forms/reports in any of your Access applications.