Save Changes to Report?

Maritza

Information *****
Local time
Today, 13:57
Joined
Nov 13, 2002
Messages
54
I'm working with Access 97, windows 2000.

I call a report from a form with the following code:
dim strSQL as string
strSql = "Select * from tblInvReports where invDate = " & "#" & dtdDate & "#"
DoCmd.OpenReport "rptInvoices", acViewDesign
Reports("rptInvoices").RecordSource = strSql
Reports("rptInvoices").lblSummary.Caption = "Summary for " & strSumOfSS & " Standard Services" & vbNewLine & "Post Name: " & strPostName
Reports("rptInvoices").lblTitle2.Caption = strSumOfSS & " Standard Services Cost Breakdown" & vbNewLine & "Post Name: " & strPostName

This work, with the exception that I would like to preview the report and close it without having Access asked me if I want to save the changes. I don't want to save the changes. How do I do that?

Thanks,

Maritza
 

Users who are viewing this thread

Back
Top Bottom