Putting data from a form into a report

[fargo]

I have created a simple program that calculates cost and materials for a given suspended ceiling via a form.
Next I want to insert all the data from the fields on my form into a report and to carry out further calculations and add further details to the same report. Should I use VBA or Macros to do this and if so could anyone point me in the right direction or to an example of a similar application.

Many thanks.

 

[Computethis]

If your Form is entering that data into an underlining table and doing calulations you could simply use a query to produce the results to a report.

Example:

CeilingSquare: [CeilingWidth] * [CeilingHeight]

Put that in a column of a query based of a table that has the two basic amounts and then your query will do the math for you each time you call up the report...

This is just a quick simple example - hope this helps...