turn off filter an move between records

[simon551]

Hi. I'm using Access 2007 and trying to turn off a filter on my form. I saved this bit of code some time ago to do this, but it doesn't seem to work. It's possible it never did/caveat.

‘Turn Filter off and move between records

If Me.FilterOn = True Then
Me.Recordset.FindFirst Me.Filter

Me.FilterOn = False
End If

The idea is that a user navigates to a detail page from a page that lists transactions. User then can 'turn off the filter' and navigate between records. But I would like the user to be remain at the record they are viewing and then be able to nav. any suggestions?

Thanks!
-s

 

[simon551]

sorry. stupid. I found the post I submitted here and PHV's advice. I saved the code wrong.

it should be like this:

Me.FilterOn = False
Me.Recordset.FindFirst Me.Filter

cheers