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?
 
Top