Hi, I have just been reading the past few days and found an item that answers my question - in a round about way - by adding a 'Save Record' button I can update the Expense Totals field by clicking on the button.

If anyone has a better idea I would still be interested.

This will teach me to read before posting! Sorry.

Susan

if your expense totals field is physically saved in your table and it is a calculated field then i think your on the wrong track. calculated fields are not suppose to be saved with your details. better have it displayed on the forms only, don't bother saving it.

Hi Joey

Thanks for your reply, 'expense totals' is a calculated field on my main form, not saved, it just updates the calculation when you click on the 'Save Record' button.

In fact I think I've cracked this database, at last. Just need to run it in parallel with the spreadsheet for a while to find any bugs. I think - I will be back - as someone famous used to say!