I am trying to filter information in a table like you can filter information in columns in Excel. For example, if I have a table with data in it like dates and times and I wanted to filter to find all records with the date of 2/5/2008, how could I do that easily? Can it be a drop down box like in Excel. I'm making a program for someone, and I don't want for them to be able to change anything in the program so I have disabled viewing of some toolbars, besides, the filter button in the toolbar never does what I want it to do.

Thanks!

Most of us never let user work directly in tables anyway, so we'd probably create a form to gather the user's choice(s) and present the results in a form or report. If you'll have a number of fields that the user may or may not want to filter on, there's a sample db here that demonstrates one way to do it:

http://www.mdbmakers.com/forums/showthread.php?t=4895