Thanks to the good people on here I am so close to what I want my table to do. So thanks guys.
2 quick questions:
1) On the drop down list box I am using to search my table is there a value I can put for ALL (show all records)?
2) In the event that there are no records to show is there a bit of code to add "No records to show"?
Once again guys thanks for all your help.