List of Values pops up when clicking save button

[Mike Treinen]

I am designing forms with Oracle Forms Builder 9i
I have a Text Field with a show_lov command in the
when-new-item-instance trigger. The problem occurs if the user leaves
the cursor in the text box with the show_lov command, and then clicks
the Save button on the Forms toolbar. After clicking the save button,
the LOV box pops up again, wanting the user to select another value.
The user can click cancel, but it is just annoying for the LOV to pop
up after each save, and I am wondering if there is anyway to fix this
problem.
Any help would be greatly appreciated
Thanks

[Newsgroups]

My customer's standard is the when button double click.

"Mike Treinen" <mtreinen@kbkids.com> wrote in message
news:c2d66e6f.0307010810.2daad29e@posting.google.com... I was told that putting the show_lov in the WNII trigger was the best way to get the LOV to show. Is there a better way to do this? I want the user to click the text_item and have the LOV appear. Thanks for your help. Mike Treinen Daniel Morgan <damorgan@exxesolutions.com> wrote in message
news:<3F00CF11.C022E806@exxesolutions.com>... Mike Treinen wrote: I am designing forms with Oracle Forms Builder 9i I have a Text Field with a show_lov command in the when-new-item-instance trigger. The problem occurs if the user leaves the cursor in the text box with the show_lov command, and then clicks the Save button on the Forms toolbar. After clicking the save button, the LOV box pops up again, wanting the user to select another value. The user can click cancel, but it is just annoying for the LOV to pop up after each save, and I am wondering if there is anyway to fix this problem. Any help would be greatly appreciated Thanks Why is the code in the WNII trigger? On what basis was this decision made?

[Tiago Rocha]

"Mike Treinen" <mtreinen@kbkids.com> escreveu na mensagem
news:c2d66e6f.0307010810.2daad29e@posting.google.com... I was told that putting the show_lov in the WNII trigger was the best way to get the LOV to show. Is there a better way to do this? I want the user to click the text_item and have the LOV appear. Thanks for your help. Mike Treinen

Set the ITEM property "Validate from list" = "yes".

-If the user enter valid data, nothing happens, user can navigate to next
item.
-If the user enter invalid data, forms will display the LOV automatically.

Don't forget to set the "List of Values" property of the item with the LOV
you want to show.

--
Tiago Rocha