I have a form with a button that exports a report to the server as a PDF. If all fields aren't filled out the report is essentially blank. All the labels are present just none of the information is there. This works wonderfully and has for some time. Today a user had an issue(unrelated to this), I put information in the record to get it started so he could open the form and modify the rest of the record. To the issue at hand that I am having. When this record is opened and output to the server it is blank. I have gone through the record both on the form and on the table and have verified more than a half dozen times each way that all required information is present. The code I am using works great for all other records, just this one doens't seem to want to work. I have tried to copy the record (done on the form) in case it had something to do with me starting things on the table and not the form, atlas to no avail. My form also checks all required fields to ensure nothing is left out so this doesn't happen and my form didn't catch anything.
I am just wondering if there is any other reason that a report would be opened up blank when all information required is present in the record. Here is the code I use for all it's worth.
I am just wondering if there is any other reason that a report would be opened up blank when all information required is present in the record. Here is the code I use for all it's worth.
Code:
DoCmd.OpenReport "TestRequestReport", acViewPreview, , "[TRNumber]= Forms!PreviousTestRequestForm!TRNumber"
DoCmd.OutputTo acOutputReport, "TestRequestReport", acFormatPDF, ToPath & "\" & MyFileName, False
DoCmd.Close acReport, "TestRequestReport"
