Creating a report based on a form

[E-D]

hi
I have a form which consists of different fields + calculated fields.
I want to create a report whose data will be taken stright from the form.
The form has ordinary fields from a query +
calculated fields (for example: field1=field2+field4)

Is that possible?

 

[Rich]

Save the form as a report.

 

[E-D]

not good

I don't want a printout of the report
I only want my report to have all the fields
used in the form.
When I save as a form I get the form's design as well.
please advice

 

[D B Lawson]

I don't think there is an easy way round it. You will have to create the report from scratch. If you have all your calculations worked out in a query, use the query as the basis of the report and then you can create the report using the wizard. If your calculations are worked out in unbound fields on the form then you'll need to recreate them for the report.

 

[E-D]

ouch! there must be an easier way..
it's a complicated report
and my calculated fields are not based on any query.

anyway thanks for the help

 

[Rich]

Now I don't understand, if you save the Form as a report the report will have the same controls as the form. Your fields aren't based on a query? they must be based on the underlying data of the form, the report will contain the same record source. Did you mean that you don't want to print all the records just the current one?

 

[E-D]

I want to print only the current report
but when I save the form as a report
the printout is colorful with all the Cmd Buttons. I wish the report to look like a report and not as a print screen shot of a form.
If you think about it I basically want to use only the fields in the form.
to your question: let me be more precise. my form is based on a query, however some fields are not (the caculated ones). I tried to build a report from scratch but I had some problem with those calculated fields.
I hope I was clearer this time

 

[Rich]

You have to do some work on the report I'm afraid, simply delete command buttons on the report, change combo's to text boxes and fore colors etc.
To open the report with current data use something like
DoCmd.OpenReport "rptName", acNormal, "", "[ReportName]![AppointmentDate]=[Forms]![frmAppointments]![AppointmentDate]"

 

[E-D]

oh! that's great. I didn't think I could work on it. great I'll do that
I hope I will manage to open the report
with the current data...
I'll try that, thanks a lot.

 

[E-D]

your way is great, however when I saved the form as a report it only saved the main report and not the sub form attached to it ?

any suggestions?

 

[Rich]

Drag the subform onto the report,to create youe sub report, remember to link the data to the main report.

 

[E-D]

the sub form is seen in the report's design mode but not when I preview it.

aren't the form + subform that I saved as a report should be already linked once they become a report?
(they were linked in the form)

 

[E-D]

Problem is solved. thanks