Paste formula result to table

[kkershaw]

I know this is bad database form, but I've considered my options and I think I need to do this:

I would like to paste the results of a formula in my form to the table. The control source is used up by my formula, so how can I get the result of the formula to post to the table?

Thanks.

 

[Ally]

Is your calculation done on the form or via a query?

If it’s via a query you could use an update query to post your ‘new field’ into your table – though why do you need to store your formula in the table?

 

[kkershaw]

The formula is on the form itself. I have no idea how I would do it as an update query. I need to put it in the table because the fields come directly from a paper form that is already calculated. This database is mostly for archival purposes rather than calculated purposes.

Thanks.

 

[David R]

Consider this, if your data is going to be archived: Will the data in those fields ever change? You can always run a query to calculate those fields when you need to pull up that data, without the extra storage space taken up with calculated fields.

Otherwise you're going to need to use an Update Query or AfterUpdate Event...