Storing values from text boxes in tables

[King]

Hi guys I have a form which has a couple of text boxes that calculate values based on results in other text boxes. Is there a way to store those results in a field in a table.

cheers

 

[Tanis]

Yes you can, but you shouldn't. Putting the results of calculated fields into a table is not necessary, as these values can be retrieved through a query. Having said that, the best way is to create a new field in your table, say fldMyNewField. Then in the After Update event of the form based on that table just place something like this.

Me.fldMyNewField=Me.CalculatedField

David