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