Do Recordsets have Filters?

[Van T. Dinh]

It will be a filtered Recordset so you will need to remove
filter if you want all Records.

HTH
Van T. Dinh
MVP (Access)

-----Original Message-----
This should be an easy one to answer. I'm assigning:

Dim rs As DAO.Recordset
Set rs = Forms("myform").[mySubform].Form.RecordsetClone

Does rs have the filter that was applied to mySubform?

Does it "know" that it has this filter? (Meaning, can I
turn it off?) I want rs to have all the records that
mySubform could contain (before filters). Should I set
mySubform's FilterOn to False before the Set line?

 

[Guest]

Yeah, trial and error proved that too me.

Thanks for your response!

It will be a filtered Recordset so you will need to remove
filter if you want all Records.

HTH
Van T. Dinh
MVP (Access)

-----Original Message-----
This should be an easy one to answer. I'm assigning:

Dim rs As DAO.Recordset
Set rs = Forms("myform").[mySubform].Form.RecordsetClone

Does rs have the filter that was applied to mySubform?

Does it "know" that it has this filter? (Meaning, can I
turn it off?) I want rs to have all the records that
mySubform could contain (before filters). Should I set
mySubform's FilterOn to False before the Set line?

Thanks for your help!
Kyle
.