Copy unbound to bound field values

[DoctorJDM]

Have a form frmJobs with a set of separate subforms to calculate total costs of materials, labour etc.

I'm bringing the subtotals from each subform into unbound fields on the main form, by setting the sources like this

Field : ubdMaterials
Source : forms!frmJobs.sfmMaterials.form.TotalMaterialCost

This is fine. I now want to use these subtotals elsewhere so is there a best way of transferring them to bound fields?
I've tried putting the bound fields on the main form then using the Close or Current events to do the updating but it's not entirely satisfactory.

 

[TheAceMan1]

How are ya DoctorJDM . . .

You write to bound/unbound the same way!

[blue]   Me!BoundName = Me!UnBoundName
or
   Me!BoundName =forms!frmJobs.sfmMaterials.form.TotalMaterialCost    
[/blue]

Its not the best Idea saving calculated results in a table!

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[DoctorJDM]

Thanks Ace

Which is the best event to trigger this if I continue?

Otherwise, if the data doesn't go into a table how would you use it in say a report that outputs the details of several Jobs?