Please Help Why wont this work?

[briggsy79]

Please Help

Why wont this work? It should open a new recordset with single record in it, the one that the cursor is at on in adoRecords

Dim nRS As Recordset
Dim b As Variant
b = adoRecords.Bookmark
Set nRS = adoRecords.Clone
nRS.Filter = Array(b)

It is then used as the datasource for a datareport

With dr
.Hide
Set .dataource = nrs
.datamember = ""

...etc
Can someone plz tell me what i am doing wrong
Thank You

 

[briggsy79]

Please!!!
There must be a reason it isn't working
The filtered recordset always has the same number of records as the first recordset. There is no filtering done!
Please help....
The bookmark is always about 512, is this correct or could this be causing the error?
-Thank You

 

[briggsy79]

There is now filtering done. But the datareport doesn't use the filtered recordset (or is doesn't look like it does).

 

[briggsy79]

I found Out!!!
i must coppy the filtered recordset to a new recordset (using a loop) then that will be the datasource.
I hope this helps people who may be having this same problem


-david