Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
datareport-ado 1
- Thread starter briggsy79
- Start date
-
1
- #2
You can filter the recordset so that it has a single record and base the report on that. Try this:
Hope this is helpful
Chaz
Code:
' oRS is your original recordset, nRS will be a copy
' The current record in oRS will be reported:
Dim nRS as RecordSet
Dim b as Variant
b = oRS.Bookmark
Set nRS = oRS.Clone
nRS.Filter = Array(b)
' Now you can run your report with the nRS recordsetHope this is helpful
Chaz
- Status