***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