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
Open Form 4
Open Form unfiltered 2
Master Child link being broken. 1
Viewing a report of filtered resutls using a Command Button. 4
Any hints/sugguestions 2
RecordCount problem 2

Top