Home » Developer & Programmer » Forms » Restrict user to choose from LOV
Restrict user to choose from LOV [message #181451] Mon, 10 July 2006 03:38 Go to next message
cong
Messages: 25
Registered: June 2006
Junior Member
how can i restrict user to choose from LOV? for example, if i click add or modify button, user should choose from the LOV and should not be able to type in the text item. thanks.
Re: Restrict user to choose from LOV [message #181902 is a reply to message #181451] Wed, 12 July 2006 02:31 Go to previous message
jowahl
Messages: 82
Registered: May 2006
Member
first you have to attach a LOV to the text item (or attach it programmatically at runtime). set the property "validate from list" to Yes.

in the WHEN-BUTTON-PRESSED triggers enter the code

GO_ITEM('<BLOCK.ITEM>');
LIST_VALUES;

to prevent user to type in the text field, set the properties to insert_allowed=No, update_allowed=No and enable them only before LIST_VALUES starts.

after LIST_VALUES you have to disable it again.



Previous Topic: View Query
Next Topic: attach multi-column of LOV with multiple display-items
Goto Forum:
  


Current Time: Fri Sep 20 09:53:49 CDT 2024