Re: Forms 5.0 list of values

Hi Martina,

There are some ways to solve that...

[Quoted] [Quoted] First of all try to set the button as not mouse navigable. Maybe it'll be enough...

If it's not enough in your case, try to use record validation instead of item validation (set Database->Validation Unit form property to Record). And set Data->Required item property to No. In that case you'll be able to use keyboard navigation as well. But you should check if the value in that item is null in the record validation process...

Hope that helps.

If you need more details let me know...

Valeri

Martina Scholz wrote:
>
> Hi Jim,
>
> thank you very much. It works but we have another problem.
> The item with the LOV is a not null field in our table.
> When entering the field you have to enter a value before you can go to
> the button that has the LOV associated with it.
> If you try to push the button without entering a value it doesn't
> work.
>
> So what can we do??? What's wrong?
>
> Thanks
>
> Martina
>
> Jim West schrieb:
> > Yes it's possible. This is exactly how I do it.
> >
> > In the WHEN_BUTTON_PRESSED trigger I have this code:
> >
> > begin
> > go_item ( 'myblock.listitems' );
> > clear_item;
> > list_values(restrict);
> > end;
> >
> > Works great! The go_item sets the focus to the block item that has
> > the LOV associated with it.
> >

-- 
Valeri Sorokine
Oracle Certified Application Developer, Rel.2
ProSoft, Russia, Moscow, Information Systems Division
Phone: +7 (095) 234 0636 ; FAX: +7 (095) 234 0640
E-mail: vsorokin_at_dd.ru   ; http://www.dd.ru