Can't See an Instanced report. Really need Help

  • Thread starter Thread starter Edgar
  • Start date Start date
E

Edgar

Hi Everyone,
I got this problem:

Public MyReport as Report
set MyReport = Report_Volume

and Now,
DoCmd.OpenReport MyReport, acViewPreview, Criteria
But It doesn't show anything.
I added -- MyReport.Visible = true -- and then it shows the report
Without
any Filtering. It Shows the report in he original State Exactly as
Report_Volume looks like.
I Think MyReport.Visible = true is giving me a trouble opening the
source report (Report_Volume). What I need is to know Why MyReport doesn't
show up with the Docmd order.

Please, help is required for half a Day of no resolutions

Thanks a lot for your considerations.
 
I found the problem
DoCmd.OpenReport MyReport.Name, acViewPreview, Criteria
that's the rigth string.

I'm sorry for the space
 
Hi Edgar,

All you really need is one line:


DoCmd.OpenReport "Report_Volume", acViewPreview, Criteria

or

Dim strReportName as String
strReportName = "Report_Volume"
DoCmd.OpenReport strReportName, acViewPreview, Criteria


The way you are doing it works, but it takes more lines and is a round about
way.

HTH
 
Back
Top