Launching report (reprint) from datasheet unable to pass needed parameter

[Chris033115]

I have created a report that prints a transaction input via a form. All the data has been posted to tables while the document details are still on the form. The source for the report is a query that gets its "Document ID" from the current form as its CRITERIA. This works fine. I click a button and the report prints.

Now I've added a datasheet that lists all the "Document IDs" that have been posted within a given date range. I've added a Macro to open(reprint) the same report when any Document ID is double-clicked. This is working except that it prompts for a Parameter Value and references Forms!DocDataEntry!txtDocumentID. (Note: this is the name of the original data entry form which is no longer open)

If I manually type the Document ID (that I just double-clicked) in the parameter box, the report prints correctly. But this shouldn't be necessary.



I know I'm missing a WHERE clause on the Macro that opens the report but nothing I've input works. I can't even hard code a document number. Actually any Where clause provided prompts additional parameter boxes to open and they ALL require the SAME INFORMATION... the Document ID.

Any suggestions???? I'm thinking that the Criteria on the Document ID in the query should be changed to allow a Document ID from any active source.

[June7]

If possible, would be difficult and require VBA custom function.

I never use dynamic parameterized query. I also don't use macros, only VBA. Review: http://www.allenbrowne.com/ser-62.html

[pbaldy]

I would remove the criteria from the query and use this, which would let it be used from anywhere:

http://www.baldyweb.com/wherecondition.htm

[Chris033115]

Thanks! That works. It provided the report but sent it straight to the printer so I made a couple changes:

DoCmd.OpenReport "DocumentReporting",acViewReport , , "DocumentID = '" & Me.txtDocumentID & "'",acDialog

[pbaldy]

No problem. Personally I'd use acViewPreview, but either will work. I use the format events sometimes, and they don't fire in Report view.

[Chris033115]

I started with the print preview but it defaulted to 45% or something like that and I couldn't find where I could change the setting for it to be full size. I've only been working with Access for a little over a month... and greatly appreciate the help I've gotten on THIS forum.

[pbaldy]

You should be able to add this after the OpenReport line:

DoCmd.Runcommand acCmdZoom100

There are other options for the percentage.

[June7]

A report should open to zoom level it was previously closed from.

[pbaldy]

Not in my experience, and if a method to force it to open like you want exists, why not use it rather than rely on "should"?

[June7]

Interesting, thought sure I had experienced that but having difficulty replicating right now. Oh well, as you said, code does the trick, although I haven't needed it. My reports open to full page view.

Try setting report properties:

DefaultView: Print Preview

FitToPage: Yes