Solved Importing values on a form into a report

[HealthyB1]

I would like to import the contents of some text boxes on a form into a report that is called from a command button on the form
On the form i calculate things like the total materials cost, total labor cost, Sales tax, discount percent given on this order etc
I then call/open an invoice report which via a query has the customers, name, address etc
I'm having a mental blank on how to import some of the calculated fields on my form into the invoice.
Thanks in advance.

 

[DHookom]

You can either calculate the values or reference the form and control in a text box on your report like:

Control Source: =[Forms]![employee details].[First Name]

 

[June7]

Why would you NOT do these calcs in report?

 

[Pat Hartman]

Why would you NOT do these calcs in report?

or better yet, in the query so you only do them once and it fills the form and the report.

 

[HealthyB1]

or better yet, in the query so you only do them once and it fills the form and the report.

On my form I specify if the client gets trade pricing as distinct from Retail pricing on materials & labour, also if Sales tax is applicable or not for this job.
I found that running two subreports on the invoice report did not always give the right answer. I tried using TempVars but again was not getting consistent results. By using the solution proposed by DHookum the problem has been solved.
Thanks to every one who has made suggestions. As previously mentioned the problem is now solved thank you

 

[Pat Hartman]

If you are happy with that solution, who am I to argue. The limitation is that you MUST have the form open to the correct record when you run the report. This seems like it could easily be a point of failure.

 

[June7]

On my form I specify if the client gets trade pricing as distinct from Retail pricing on materials & labour, also if Sales tax is applicable or not for this job.

This data is not saved to a record?