Hi
I have one underlying record set for a particular form. One of the fields automatically updates the underlying table being based on a calculation from another field. ie the field that needs updating is bound to the table.
I can use the update event or similar on the calculated field to tell the bound field to update but I'd like this to happen automatically, for example when you move to the next record the field is automatically updated rather than having it done on, say, a button press.
As there is no "on moving to antoher record" event (!!) would anyone have any ideas?
Many thanks
Andy
I have one underlying record set for a particular form. One of the fields automatically updates the underlying table being based on a calculation from another field. ie the field that needs updating is bound to the table.
I can use the update event or similar on the calculated field to tell the bound field to update but I'd like this to happen automatically, for example when you move to the next record the field is automatically updated rather than having it done on, say, a button press.
As there is no "on moving to antoher record" event (!!) would anyone have any ideas?
Many thanks
Andy
