Exporting a form to a report

[klwilbur]

I have a form that pulls a number of records from a number of different tables. I want to see basically the same information in a report. Is it possible to export the set up to a report so I don't have to build a report from scratch?

Thanks,

Kelly

 

[pbaldy]

Try right clicking on the form in the database window and selecting Save As, and choose Report. Probably won't be perfect, but might save you some work.

 

[klwilbur]

Try right clicking on the form in the database window and selecting Save As, and choose Report. Probably won't be perfect, but might save you some work.

The option to Save As a report is not available. I can only Save As a form or a Data Acess Page.

Any more ideas?

Thanks,

Kelly

 

[pbaldy]

What Access version? I've got A2k, and the only options I get for the Save As are Form and Report.

 

[klwilbur]

I see the trick. You only get from and Data Access page if you select Save As from the top menu when the form is open. You have to select, but not open the form and then click Save As to be able to export it as a report.

Thanks,

Kelly

 

[pbaldy]

Sorry, that's what I meant when I said "in the database window". I should have made it clearer. Hope it works for you.