***RESOLVED***Crystal Report Not Updating

[Jefftopia]

I have a form which I use to update a Microsoft Access db. I am using an external crystal report (not using report design component) to display the data in my db. The problem is that when a user goes into the form and makes a change to the database, the change is not reflected in the report until the user closes and restarts the application.

I am not sure if I need to be doing something to the report or the code which calls the report.

Here is the code I am using to call the report:

vbcode
Private Sub mnuLoanActivity_Click()

Screen.MousePointer = vbHourglass
With frmRptView
.Show
.CRViewer1.ReportSource = rptPrimDls3
.CRViewer1.ViewReport
End With
Screen.MousePointer = vbDefault

End Sub
/vbcode

[Buzby]

Open the report in Crystal and make sure "Save Data With Report" is NOT ticked. I think it's on the FILE menu.

[Jefftopia]

Thanks. That was not it as it turned out. I needed to use refresh property of viewer.