Hide subform when empty

[mayardbj]

Hello
I have a form with subform.
The sub form is always visible, even if it is empty, it is showing NO RECORDS FOUND.
See attachment

I would like to hide the subform or the block when it is empty.

[aamartinezz]

Hi
in the load event (in the main form) check if there are records and hide the block if not

/**

• Hide/show a block
  */

if ({field1} == ‘some_value’) // Display block
{
sc_block_display(block1, ‘on’);
}
else // Hide block
{
sc_block_display(block1, ‘off’);
}