How do I create a report that asks for the user to enter the displayed data?

[amayer]

I want to create a report which asks the user a series of questions, and which will display the answers in the report. This is for manually creating shipping forms for items which don't need to be in a tablespace anywhere. I have gone the long way with creating query's macro's table's form's etc. but there seems like there should be a simpler method. Thank you in advance for any help.

tony.

 

[jatfill]

there is.

Method #1
Add a text box to your report field and set the control source like the following:

=[Enter Information Here:]

replace "Information Here" with the prompt you want the user to see. This will cause a box to pop up any time the report is opened, querying the user to enter the field value.

Method #2 (recommended)
If you have a several fields like this for the report, create a form with all the necessary field values on it so the user can fill out & inspect what they have entered before they print...

link the fields on the report to the fields on the form (DLookUp function)

add a command button to the form that prints the report, and that will take care of it...


I recommend method #2 because then you can incorporate error checking, and require values to be entered before the report can be printed... the keyword is "idiot-proofing" ;-)

hth

 

[amayer]

I spoke too soon! I tried method one and it returns a value of #name? each time I open the report. I will move on to method two. Thanks again.

tony.

[This message has been edited by amayer (edited 07-11-2001).]