i am trying to show only a single record in a datareport (the record another form is viewing), 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.
plz help...
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.
plz help...