OraFAQ Forum: Forms » open form on specific record after click on list button

Home » Developer & Programmer » Forms » open form on specific record after click on list button (Forms 10g, Win 7)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

open form on specific record after click on list button [message #487787]

Fri, 31 December 2010 05:21

obeide
Messages: 8
Registered: December 2010

Junior Member

I have a list box from which the user can select a client's name, I want them to be able to press a button next to the box which will then open another form and display all the client's details. How do I attach a button to a list box? and how can I call another form to open on a specific record?

Thank you.

Report message to a moderator

Re: open form on specific record after click on list button [message #487797 is a reply to message #487787]

Sat, 01 January 2011 04:47

ranamirfan
Messages: 535
Registered: January 2006
Location: Pakistan / Saudi Arabia

Senior Member

Dear,
For displaying client's detail against client Name / Id,you can use Default_where clause and Stack canvas.

As a sample pls see below code.


If :global.employee_id is not null then
v_emp_where := 'employee_id = ' || :global.employee_id;
Set_block_property('ia_employee', default_where, v_emp_where);
go_block('ia_employee');
Execute_Query;
End if;

Hope you'll got idea.

Regards,
Irfan

Report message to a moderator