I have Form A with a lookup field to Form B. This look up field retrieves the value from Form B and fetches corresponding data from that report. 

The fetched data is only accurate at the time of user input in the lookup field - if Report B changes; then the data is now out of date. I have written the following function to update the records in Report A to capture any changes but this has to be executed manually;