Generate Report from query to look like form

[Guest]

I would like to generate a report from a query (so I can use parameters) but
would like the report to automatically set up to look like my forms. Can I do
this?

 

[Jeff Boyce]

Reports and forms are two totally independent types of objects. I'm not
aware of a way to use a form as a "template" for a report.

But you could try printing the form...

Forms are usually optimized for display on screen. Reports are usually
optimized for printout.

Why do you want a report that looks like a form?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Van T. Dinh]

In the Forms tab of the Database Containers window, right-click on the Form
that you want the Report to look like and select "Save As ..." in the
context-sensitive menu. When the dialog comes up, select Report in the
"As" selection box.

You can the modify the Report to use your Parameter Query (assuming that the
Form's RecordSource and the you Parameter Query are similar in structure).

 

[Jeff Boyce]

?!? You can do that ?!?

(thanks, Van!)

Jeff

In the Forms tab of the Database Containers window, right-click on the
Form that you want the Report to look like and select "Save As ..." in the
context-sensitive menu. When the dialog comes up, select Report in the
"As" selection box.

You can the modify the Report to use your Parameter Query (assuming that
the Form's RecordSource and the you Parameter Query are similar in
structure).