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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can't Refresh using a Recordset

Status
Not open for further replies.

Blauther

Programmer
Jan 8, 2002
15
US

I am having the same problem that other people have had in other threads...I have a report that works fine, but the data does not refresh unless I hit the refresh button (Lightning Bolt). Their solution was to "not use "Save Data With Report". I am not sure where to find this option, or even if this option applies to my situation.

I am going to clarify this a little further...The data DOES refresh if I close down the VB app and restart it, but if I run the report Twice within the same app instance, the changes are not shown unless I hit the refresh button. The vb app is returning the correct recordset...That was the first thing I checked.

Code:
m_Report.Database.SetDataSource (Insert Recordset Here)
CRViewer1.ReportSource = m_Report
m_Report.txtReportTitle.SetText "Pets On Hold"
CRViewer1.ViewReport
CRViewer1.Zoom (100)

--CR version: 8.5 Developer
--report connects to the data via: ado Recordset
--The version of VB: 6.0 SP4


Thanks in advance for any help!
--Brian
blauther@SoundSoftware.cc
 
Nevermind...I figured it out...here is the line of code that I added:

m_Report.DiscardSavedData
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top