I have a form with a option group called Region. The options are
When someone clicks on West within the option group a Case statement determines the Option value selected and re queries the data to show only the records for the value selected (in my example then only West records would display. If someone selects South all the records for South appear, etc...
However, my dilemma is what if someone wants to view 2 values such as South and West...The below link shows the basic structure of my option group and form using a Case Statement. http://www.databasedev.co.uk/option_group_filtering.html