GeneralShamu
Board Regular
- Joined
- Jul 6, 2007
- Messages
- 127
Here is the code I am trying to run:
Forms![FormName]![LstBSource] = "SourceName"
Forms![FormName]![LstBVariable] = "VariableName"
DoCmd.OpenReport "ReportName", acViewDesign
Reports![ReportName].Caption = "VariableName"
DoCmd.OpenReport "ReportName", acViewNormal
For some reason though, it does not work, the pdf that is created is blank where charts/data would be pulled in. (The page is not completely blank, there is a title and column headings.)
I have several SourceName/Variable Name combinations (100+) so I have these 5 lines of code repeated as many times in one big VBA code file in Access.
What am I doing wrong to convert this to a PDF?
Forms![FormName]![LstBSource] = "SourceName"
Forms![FormName]![LstBVariable] = "VariableName"
DoCmd.OpenReport "ReportName", acViewDesign
Reports![ReportName].Caption = "VariableName"
DoCmd.OpenReport "ReportName", acViewNormal
For some reason though, it does not work, the pdf that is created is blank where charts/data would be pulled in. (The page is not completely blank, there is a title and column headings.)
I have several SourceName/Variable Name combinations (100+) so I have these 5 lines of code repeated as many times in one big VBA code file in Access.
What am I doing wrong to convert this to a PDF?