SOS+Urgent,how to call a form by clicking submenu??

[tlgagape]

1) i don't use the default and smartbar menu for my program..

i intend to create my own menu.

so i make 3 menus : view, insert, search.

and in view menu i make a submenu named : FILM, this sub menu i intend to call the iflm form, that already has been compiled.

in the menu editor, after right clicking and choose the FILM submenu, i choose the PL/SQL Editor,
and type the following script :

RUN_PRODUCT(FORMS, 'E:\IFILM.FMX', SYNCHRONOUS, RUNTIME,

FILESYSTEM, '', '');



e:\ is where i put the ifilm.fmx and ifilm.frm

and i put a menu in a blank form, and i compile and run it. but when i click the FLM submenu there's an error message :


FRM-10242 : CANNOT CALL LINKED IN FORMS FROM FORM BUILDER.

how to fix this problem??

and the second question is :

cause i didn't want to use the default&smartbar menu, so to insert a record i create a button.
and the PL/SQL Editor is :

declare
msg varchar(30);
begin

commit;
msg:='error';
exception when dup_val_on_index then bstars.text_item5:=pesan;
raise form_trigger_failure;
end;

but when i compile it, there's an error message : bstars.text_item5 must be declared.

ps : bstars is the name of the current form. could you help me why this is happen??

and how to put a text in text_item??

could you guys help me please?

i really need the answers, cause the deadline of my project is almost one week again.

thanks,thanks, and thanks before.

 

[lewisp]

Try using CALL_FORM, OPEN_FORM or NEW_FORM instead of RUN_PRODUCT.

To assign values to items in a form you need to use COPY:

[tt]COPY('text','BLOCK.ITEM');[/tt]

Do not specify the form name, but use the block name where the item is located.

 

[Khayyam]

use the call_form or Open_form method