form, updating records

[jacks]

I have a table with over 300 records. For every record I want to do some calculation.. therefore I have a button on the form : "calculate"

Whenever I change the calculation, I need to update every record by going through all of them and click the button to do the required calculation. That's a bit tedious to do.. how do I automate that ?

 

[Rank Am]

Easiest way, if it's an arithmetical calculation would be via a query or a form bound to query. The variables in the calculation can be changed in the form then applied to all records and the table updated. If the actual calculation itself changes the you will need to add an additional Expression(s) to the query. If each record requires different variables then you may need to look at your DB design or you may have no choice but to manually update 300 records.

Regards

Jonathan