Avatar

Level 10

Hi,

I think a mixture of Paul's and Stephen's solution would work for you:

  • Set up the invisible/visible subform. This could be over the normal form objects, because it will be hidden from normal users.
  • As Paul says you could set its presence based on the exit events of each of the fields in the subform. If all fields are not null, then hide subform. This would encourage the sales team to fill in the data, as this would be the only way to hide the subform. You would delete the 'Hide Subform' button.
  • Then you could implement Stephen's solution as a means of showing the subform again, eg typing in set data into three fields that are normally visible.
  • I would be inclined to have script clear the data in the invisible/visible subform when it is made visible again, so that the data has to be inputted from scratch. This will help the exit scripts in these fields.
  • A docReady event script could check the values of the fields in the invisible/visible subform and if any of these are null, the subform presence would be set to visible.
  • Remember to set the 'Save script changes' to Automatic in the File > Form Properties > Defaults window.

Close to workable,

Niall