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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

FBIAGENTCommented:
In Oracle forms, you may use built-in procedure CALL_FORM(...) to open form #2 from form #1 (e.g., via a button)
schwertnerCommented:
Use NEW_FORM builtin

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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 :)

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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.