Report prompts for info again when you print the report

[CanBOnly]

I have created a report and it prompts for user input on one of the fields and then the report displays correctly. However when I print the report (using the print button in access) the report prompts you for the information again. I just used a inputbox command in the report here is the expression I am using:

=InputBox("Enter Document Number for license # " & [CredentialHolderPublicNumber])

Again the report works correctly but when you print it prompts for the input again. Is there a way to suppress the second set of prompts when I print

 

[Darrylles]

Hi CanB,

The problem is that the report does not have this information in a table etc.

The best way around this is for you to give the user access to a button, which runs a form (eg frmPrint) that requests this information. When the info is input by the user, frmPrint runs the report and have the report fill the particular field by referencing frmPrint.

e.g. in the report field 'Control Source' property use this:

=forms!frmPrint!txtDocNumber

where txtDocNumber is the textbox on frmPrint where the user types in the document number.

ATB

Darrylle



Never argue with an idiot, he'll bring you down to his level - then beat you with experience.