In When-New-Record-Instance, check if the block status is NEW. If Not, then just apply COMMIT_FORM;
try this code in your trigger
IF :SYSTEM.BLOCK_STATUS = 'CHANGED'
Should work for you.
I'm not sure why you would want to use the COMMIT_FORM in a When-New-Record-Instance (WNRI) trigger; do you really need your Form to call COMMIT_FORM everytime Forms instantiates a new record?
My quess is that you have more going on in the WNRI than just the COMMIT_FORM. Can you show us the code in your WNRI trigger? Is there a reason you need to commit when navigation moves from one record to another?
Hey thanx a lot abbas85 for the quick reply.
This has solved the issue.
It is also working fine with :system.form_status as well.
Sorry for the late reply..!!
Thanx a lot Craig for the shown concern..!!....