To programmatically open another form:
When you open a form with ACTIVATE specified, Oracle Forms ignores (and never executes) any trigger statements that follow the call to OPEN_FORM.
If you do not want Oracle Forms to place focus in the opened form, include the NO_ACTIVATE parameter:
OPEN_FORM('stocks', no_activate);
When you open a form with NO_ACTIVATE specified, Oracle Forms executes any trigger statements that follow the call to OPEN_FORM after the opened form has been loaded into memory and its initial start-up triggers (if any) have been fired.
Whether you open a form with ACTIVATE or NO_ACTIVATE, Oracle Forms will fire any triggers in the opened form that normally would fire at form start-up. Potentially, these could include Pre-Form, When-New-Form-Instance, When-New-Block-Instance, When-New-Record-Instance, and When-New-Item-Instance triggers.
To close an independent form: