Creating a Report from a Form

[Brian Beck]

I've spent the last 2 hours creating and tweaking a form in Access 2003 for
viewing data that was submitted through a web form. I want to add a command
button that will allow a user to print the record that they are currently
viewing in the form...however, everything I've found refers to having the
coding for the print button simply send the primary key for the record to
the report that I want to print and then it will print out. But my form IS
my report. All the data I would want to show in the report is shown in my
form. Does this mean that I have to go through the whole process again of
creating a report and tweaking the formatting even though I just did all of
that for my form? Or is there some simpler way to import my form into a
report and use it that way?

-Brian Beck

 

[Guest]

What I would suggest is that you save your form as a report, create a
separate record source for the report that uses criteria based on the current
record in the form

 

[Jeff Boyce]

In addition to Jeff C's suggestion, bear in mind that the appearance/design
of how you present data on a screen (i.e., a form) is rarely also a good
design/appearance for how you should print out the data (i.e., a report).
While it is possible to use a "form as a report", that doesn't mean its a
good idea to.

Regards

Jeff Boyce
Microsoft Office/Access MVP