If I use a filter on my form, will the recordsetclone reflect the filtered form or the unfiltered fo

C

Chris K

If I use a filter on my form, will the recordsetclone reflect the filtered
form or the unfiltered form?
 
J

Jeanette Cunningham

The recordsetclone will reflect the filtered form.
You can test this by putting code like this after the code that does the filtering.
Debug.Print Me.RecordsetClone.RecordCount



Jeanette Cunningham MVP (Access) Pakenham Victoria Australia
If I use a filter on my form, will the recordsetclone reflect the filtered
form or the unfiltered form?
 
C

Chris K

Thanks
The recordsetclone will reflect the filtered form.
You can test this by putting code like this after the code that does the filtering.
Debug.Print Me.RecordsetClone.RecordCount



Jeanette Cunningham MVP (Access) Pakenham Victoria Australia
If I use a filter on my form, will the recordsetclone reflect the filtered
form or the unfiltered form?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Prohibit Filter Off 3
RecordsetClone on a subform 3
=sum with a filter 2
Open Form 4
Open Form unfiltered 2
Request Form - Alert Team Member 0
I figured out the issue thank you. 0
Clearing combo boxes and a text box 2

Top