View Full Version : Blank report printing


Sam Summers
01-06-2004, 12:12 PM
I had this working many times before but due to the brilliant design of Microsoft software it is not working know.
I am probably missing something simple (again!!!).

I have a report that has many subreports, however the main report is based on a query "AccessManifest" which runs fine. I have tried to print the report in two ways:

Based on the form 'ManifestDetails'-

stDocName = "Manifest"
stLinkCriteria = "[JobNo] =" & " ' " & Me![JobNo] & " ' "
DoCmd.OpenReport stDocName, acNormal, , stLinkCriteria

*******************************

And also tried by setting the query parameter for the Field "JobNo" from the "Location" Table to [Forms]![ManifestDetails]![JobNo]

In all cases i just get a blank report !!!!!!!!!

Thank you greatly in advance

Rich
01-06-2004, 12:23 PM
Is JobNo numeric or text?

Sam Summers
01-07-2004, 11:48 AM
Hi Rich

JobNo is a text field.

Thanks for taking a look.