report vs form

[spcscooter via AccessMonster.com]

I have a report that I want the user to be able to type information into and
then be able to print that report to file. But when I go to type something
and hit enter the information goes away. Is it possible to make the info
stay while the report is open or do I need to figure out how to do this in a
form? The problem is that I don't want the information stored in Access.

Hope that is enough info.

Thank you,

 

[Jeff Boyce]

Reports in Access are based on data stored in tables. If you don't want
Access to store the data, why are you using Access to build the report?

Have you looked into using Word?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[spcscooter via AccessMonster.com]

What I'm doing is kinda weird. About half the information from the report
comes from Access and the other half the user needs to input themselves. The
report is being used as a PO and the numbers from the PO cycle between 1 and
50. So all we are going to do is do a print to file to store the information
digitally and then a hard copy for redundancy. I was thinking of trying to
use =nz([Enter required information]) in each of the fields that the user
needs to fill. This way it will be a prompted task to the PO and the
information would not be stored in Access.

Thoughts?

Reports in Access are based on data stored in tables. If you don't want
Access to store the data, why are you using Access to build the report?

Have you looked into using Word?

Regards

Jeff Boyce
Microsoft Office/Access MVP

I have a report that I want the user to be able to type information into
and

[quoted text clipped - 8 lines]

Thank you,

 

[John W. Vinson]

What I'm doing is kinda weird. About half the information from the report
comes from Access and the other half the user needs to input themselves. The
report is being used as a PO and the numbers from the PO cycle between 1 and
50. So all we are going to do is do a print to file to store the information
digitally and then a hard copy for redundancy. I was thinking of trying to
use =nz([Enter required information]) in each of the fields that the user
needs to fill. This way it will be a prompted task to the PO and the
information would not be stored in Access.

Another possibility would be to have a Form with unbound textboxes for the
user-entered information; the Report would have textboxes with control sources
like

=Forms!frmPOEntry!controlname

to reflect what's in the form on the screen.

If a user will be entering and printing multiple PO's you will really need to
store the information in a temp table.