Generate Report from query to look like form

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?

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


"yorkielover02" wrote in message
...
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?

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).

--
HTH
Van T. Dinh
MVP (Access)



"yorkielover02" wrote in message
...
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?

?!? You can do that ?!?

(thanks, Van!)

Jeff

"Van T. Dinh" wrote in message
...
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).

--
HTH
Van T. Dinh
MVP (Access)



"yorkielover02" wrote in message
...
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?