I'm using Access 2003
My data source for the DAP is a query, the query has a calculated feild that adds five other fields in the same record.
The user has reported that it no longer totals the feilds. I checked the query and found that the query was fine. I have made no changes to the query or the page in several months. There have been no changes made on the server.
I did find that now, instead of the total changing as soon as the user tabs off of a field that he changes, you have to save the record and refresh the page to get the calculated field to update.
What would cause that to change? Is there a seting somewhere that would put it back the way it was?
Thank you
VE
My data source for the DAP is a query, the query has a calculated feild that adds five other fields in the same record.
The user has reported that it no longer totals the feilds. I checked the query and found that the query was fine. I have made no changes to the query or the page in several months. There have been no changes made on the server.
I did find that now, instead of the total changing as soon as the user tabs off of a field that he changes, you have to save the record and refresh the page to get the calculated field to update.
What would cause that to change? Is there a seting somewhere that would put it back the way it was?
Thank you
VE