Oracle Forms Call

I have 1 form open (form 1), when I open my new form (form 2), I want the form 1 to close or deactivate...using the exit_form, close_form isn't working...is there some bug?

Is there a way to deactivate form 1 when I open form 2, and when I close form 2, form 1 will reactivate?
camposaaAsked:
Who is Participating?
 
schwertnerCommented:
Use NEW_FORM builtin
0
 
FBIAGENTCommented:
In Oracle forms, you may use built-in procedure CALL_FORM(...) to open form #2 from form #1 (e.g., via a button)
0
 
BILL CarlisleAPEX DeveloperCommented:
I believe you want to call a new form (form2) from form1 and have the calling one (form1) close. Now form2 is open ready for use.

Bill :)

0
 
BILL CarlisleAPEX DeveloperCommented:
Oh, schwertner hit it on the nose.

NEW_FORM builtin

Exits the current form and enters the indicated form.  The calling form is terminated as the parent form.  If the calling form had been called by a higher form, Form Builder keeps the higher call active and treats it as a call to the new form.  Form Builder releases memory (such as database cursors) that the terminated form was using.
Form Builder runs the new form with the same Runform options as the parent form.  If the parent form was a called form, Form Builder runs the new form with the same options as the parent form.

Great! I didn't know that.... :)

Bill
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.