Form Template to Report

[PATRICKPBME]

I ran a query and created a form that met all my needs for inputing data to the main database. Now I would like to use that very same format for a report that I can run for individuals. Is there a way I can use that form template/design for my report template/design (i.e. cut and paste)? If possible, I would like to avoid having to design a report template with the exact fields and information from scratch.



Thanks in advance.

[ranman256]

The report is based on a query.
the query will use objects on the form....
select * from table where [dept]= forms!myForm!cboDept

this way only the dept on the form will show on the report.

[pbaldy]

Select the form in the navigation pane, then

File/Save Object As

and change the "As" to Report. It may need tweaking, but will give you a head start.