[AccessD] Simulate AutoFilter

I'd like to create a form in Access which simulates the AutoFilter 
functionality in Excel. Basically, it's the size of the files (1.5 million 
records) that makes Excel less useful than it would be otherwise. I doubt 
the company wants to spring for Office 2007 just now to have Excel's 
capacity increase.

Does anyone know of a sample database or just some instruction on how to 
build such a puppy? I've got about 40 fields; will this require 40  combo 
boxes, or is there another way?

TIA.

Thomas F. Ewald
Stryker Mass Properties
General Dynamics Land Systems






This is an e-mail from General Dynamics Land Systems. It is for the intended recipient only and may contain confidential and privileged information.  No one else may read, print, store, copy, forward or act in reliance on it or its attachments.  If you are not the intended recipient, please return this message to the sender and delete the message and any attachments from your computer. Your cooperation is appreciated.