Custom Search Form
Posted on 2014-11-28
I'm trying to recreate a search form (or something similar) that I used in a database i did years ago. The functionality I am after is having a search form with multiple optional criteria fields. When the user clicks "search" the detail section of the form would show the corresponding records. The user could then click on the individual record to open the details screen about that record. As I mentioned, I did one years ago that was very useful but it has since been modified heavily, and no longer works. I used "strSQL" as a variable to build a statement that would filter the records as desribed based on the users inputs but there have been too many changes to figure out what my original code was.