Report for user info again when you print

[CanBOnly]

Let me start by saying I am new to access and sql so here is what I
have done so far:

Using Access 2003 I have created a 4 column report that pulls data for
3 of the columns from a sql database. When you run the report it
prompts for the start and end dates. There are 4 columns (License #,
Name - which is made up of 4 sql fields (First, Middle, Last, suffix),
Date and Document #).

Here is my problem the Document # is not stored in a table and I don't
need to store the information in a table but I need it to prompt the
user for the information for each record and record it record and
display it on the report. I have created a report and it prompts the
user for the input and it displays correctly on the report. 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.

I know this is probably basic but like I say I am new to access and
have not ever designed any reports. Thanks in advance for any help you
can provide.

 

[Jeff Boyce]

One approach to solving your issue would be to not use the InputBox, but
rather, to create a form on which the user enters the criteria. Then you
would modify the query that gets the records you want. Finally, you'd base
the report on the query.

Regards

Jeff Boyce
Microsoft Office/Access MVP