Using an Option Box to filter a SubForm
Posted on 2011-04-22
I have created a form to search for records in my database. I am currently using a combo box to select the employee name and an option group to select record status, but I cannot seem to get a filter to work to filter by record priority. The employee name combo box is bound, and is linked to the subform with a master/child link, and works perfectly. The option box has a case select set up that changes the record source of the child to different subforms based on queries that fit the requested status priority (I could not get the filters to work here either). This is fully functional for me also, except that I want to be able to filter the subform for priority also. If I use a bound combo box with another master/child link I can effectively filter, but I can't figure out how to add an option to the drop down list that will make all records available again. Using the case select on the option group gives me the ability to remove all filters as my last option, but since I can't seem to make the filters work it's irrelevant. I'm not proficient in any kind of code, but none of the snippets I have been able to find have worked. Please help me figure out how to filter these records...