I created a database, on the switchboard the user will select a school, then it goes to a read only form that filters records only in that school. here in this form I would like to instruct the user how to filter the records by using the shortcut on the menu bar such as filter by selection or filter by form.
My problem is when I select a field and click by selection, it works fine, but after this, if I want to remove the filter, I click the remove filter button, it then shows all the records for all the schools. I supposed it only still show the specific school I selected earlier. How can I achieve that?