I have two forms each connected to the same table and am having difficulties getting calculated fields in the second form updated to reflect data changes entered in the first form. Both forms are displayed by a command button macro on the other form (using the "OpenForm" action in the macros). IOWs, when I change data in the table with one form and click the command button to display the second form, the change in data is not reflected in the respective field on the second form. The only way I can get the updated data to display on the second form is to close the form using the "Close Window" icon (above the ribbon) and re-display the form (using the OpenForm macro on the other form). It is further necessary, when changing data on a record on the first form, to display any other record on the form for the update on the second form to work.
I have tried using the CloseWindow action in the macros used to display the forms and, Refresh and RefreshRecord in various Events on the form properties such as On Load, On Open and On Got Focus but they don't seem to work.
The odd part is, this same database did not have this problem in Access 97 (which it was originally written in and then converted to Access 2010).
Any help much appreciated.......
I have tried using the CloseWindow action in the macros used to display the forms and, Refresh and RefreshRecord in various Events on the form properties such as On Load, On Open and On Got Focus but they don't seem to work.
The odd part is, this same database did not have this problem in Access 97 (which it was originally written in and then converted to Access 2010).
Any help much appreciated.......
