We have a situation where we are using EVHOT to open a detail input schedule. The detail schedule captures and submits data, and the user then closes the schedule and returns to the original report. The goal is to trigger the original report to refresh when the user returns from the detail schedule.
Does anyone know how to force this refresh? We have attempted using a button to run a macro that closes the detail schedule and activates the summary report -- which includes a BPC refresh command. However, we have not been able to get the Worksheet or Workbook events that will contain the refresh command to fire upon return.
Any suggestions would be greatly appreciated!