I am trying to create a report within my database that will display a variety of information. To get this information, I need to create a few different recordsets because the data comes from a variety of places. What is the best way to implement this? I have used sub reports in a past report, but found that it took way too long to run across a network. I know this is kind of vague, but what I'm trying to do is a little complicated and I don't want to bore you.
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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
multiple recordsets on a report?
- Thread starter striker73
- Start date
LittleSmudge
Programmer
Well the detail of your answer lies in your local set-up - but some direction I can provide.. ..
I have many report designs that are effectivly unbound reports and I run code that opens recordsets which gather and manipulate the data before writinging it to the unbound controls on the form.
You can have as many Recordsets open as you need - just call them something different
Dim rstA As Recordset
Dim rstB As Recordset
Dim rstC As Recordset
Etc.. ..
'ope-that-'elps.
G LS
I have many report designs that are effectivly unbound reports and I run code that opens recordsets which gather and manipulate the data before writinging it to the unbound controls on the form.
You can have as many Recordsets open as you need - just call them something different
Dim rstA As Recordset
Dim rstB As Recordset
Dim rstC As Recordset
Etc.. ..
'ope-that-'elps.
G LS
- Status
Similar threads
- Locked
- Question
- Locked
- Question