i am trying to show only a single record in a datareport, it isnt working. i do this (scopio66 suggested it):
Dim nRS As Recordset
Dim b As Variant
b = adoRecords.Bookmark
Set nRS = adoRecords.Clone
nRS.Filter = Array(b)
But when i set the datasource to nRS, i still get the entire database in the datareport.
Dim nRS As Recordset
Dim b As Variant
b = adoRecords.Bookmark
Set nRS = adoRecords.Clone
nRS.Filter = Array(b)
But when i set the datasource to nRS, i still get the entire database in the datareport.