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