Remove filter from Access form but stay on current record
Posted on 2008-10-08
I have an Access form that I would like to allow people to filter using the built in filter by selection. My form is set up so that the grants table is the subform of the applicant form. The built in filter works fine when I apply it but when the filter is removed the form jumps to the first record in the applicants table. I would like it to stay on the current record. I have already set the properties of all forms to current record but for some reason, removing the filter seems to bypass this.