Update Record With Value of Calculated Field

[darrelhawes]

I have a form with a calculated field. I want to populate a specific field in the underlying record with the results of the calculation. What is the best way to do this?

Darrel Hawes

 

[Chalco]

If the field is on the same record, have the field on the screen (either displayed or not) and then say me.fieldname=value

 

[darrelhawes]

Which property needs to have the expression me.fieldname=value?

 

[Chalco]

VBA code - if you create a procedure on the on-exit event to populate the field (check in the process that the source field is valid thou)