Unanswered: Filtering a query based on user choices from a form
Basically, I want to create a form that gives the user sorting options. The primary list of fields is in the first box, then once the user chooses one of htose, another drop down appears where the user chooses what to filter out. For example:
Sort by: Country <----- the user selects "Country" out of a list
Country: United States <-------- the user wants to see all
records from the United
How do I set the criteria based on those options? I've tried a number of different things... I cant seem to figure out the ApplyFilter method... especially when the parameters are dynamic. Help, please. Thanks.