In my form, I display ordinary user editable VARCHAR() type fields, and also some integer fields that are changed by triggers in the DB (These are set to "Read Only" so the user can see them, but not change them. I manually change the data in the user editable fields, then click "Save". After I click "Save", the data I changed is sent to the DB and committed, and all is working ok. However, I need to have the "trigger changed" field values show up in the record in the form, so that the user can see the new values of the "trigger changed" fields. This would be easily accomplished if I could some how do an automatic refresh of just the one record that I changed. I need: "AfterUpdate.... RefreshThisRecord" or something like that. Can anyone tell me how to accomplish this? ( I need the solution to work in both single record forms and Editable Grid forms. Thanks.
Login or Sign Up
- Log in with