Do Recordsets have Filters?

  • Thread starter Thread starter Van T. Dinh
  • Start date Start date
V

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?
Click to expand...
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?
 
Yeah, trial and error proved that too me.

Thanks for your response!

Van T. Dinh said:
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?
Click to expand...
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
.
Click to expand...
Click to expand...
 
Back
Top