Return to current record after removing filter
Posted on 2009-04-28
I've seen this type of question mentioned before, but I was unable to find a solution. I'm looking for a way to simply return to the current record on a form after removing its filter. I use the DoCmd.OpenForm method to open a form w/ filter applied & once I have the filter applied I can't remove it w/out returning to the first record in the form's record source. I've tried declaring an integer variable & assigning its value the Me.CurrentRecord property & then using the variable in the DoCmd.GoToRecord method, but was unsuccessful. Any help would be greatly appreciated.