Removing a filter while staying on the same Record

[MattMeat]

Hello Everyone!

Mattmeat Here!

Here's my problem:

I have a "search" form and a "destination" form. The "Search" form haS A FILTER and the code looks like this:

Private Sub WorkOrderNo_DblClick(Cancel As Integer)

Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "WorkOrdersCompactCopy1"
stLinkCriteria = "[WorkOrderNo]=" & Me![WorkOrderNo]
DoCmd.Close
DoCmd.OpenForm stDocName, , , stLinkCriteria
DoCmd.Maximize
End Sub


Well, when the "destination" form opens, the filter works fine. But when I try to scroll through all records, the filter is blocking my way. I tried using:

Me.FilterOn= False

Although this does remove the filter, It takes me back to record 1. Can I remove this filter while staying on the same record???

Thanks Everyone!
Mattmeat

 

[AArt]

You want to remove the filter in the "destination" form? Not sure I'm picturing your situation. But you should be able to remember the work order # in a variable. then use the FindRecord method to go to that record after removing the filter.