Filter recordset after parameter query

[kunguito]

Hi all, long time no see

I have a time consuming query that I want to run the least as possible.
However I would like to filter it afterwards using the filter property of a recordset.

It prompts the query arguments every time I reach ".filterOn=True". What can I do?



Private rsGlobal As DAO.Recordset

Private Function GetMyRecordset(args())As DAO.recordset
...
End Function

Private Sub Main()

Set rsGlobal =GetMyRecordset(args)

End Sub


Private Sub FilterProcedure(strFilter As STring)

rsGlobal.Filter=strFilter
rsGlobal.FilterOn=True

End Sub