Updating Access 2003 Table With Form Instantly... Is It Possible?
Posted on 2007-03-19
Hello, I am using Microsoft Access 2003.
I have setup a continuous form, with multiple records displayed in a single line list format. At the bottom of the list is a sum of one of the columns. Currently, I have that sum generated directly from the underlying data tables. This is fine, but due to this approach, that sum only updates when the user moves on to the next record. I would really like to trigger the data record update after that field is updated, even if the user does not move outside of that record.
So, to summarize, I would like to update the underlying table of an access form without moving to a new record. I am familiar with VBA, would some function call there be the best approach?
I am open to suggestions,
Thanks for the help.