This topic is locked

Make Field Editable in ADD but read only in Edit

3/13/2009 5:37:11 PM
PHPRunner General questions
jpedwardspost author

Hi,
I have a field set up as a list of values with the lookup wizard.
When I add a record I obviously want to be able to populate this field by picking from a list of values but when I later edit the record I want the user to be able to see the original value but not change it. In other words in edit mode this field is display only but not editable.
How can I do this? If I change the field to read only in the visual editor it changes it for both ADD and EDIT mode and my lookup pick list disappears.
Thanks,
JP.

jpedwardspost author 3/14/2009

Hi,

I have a field set up as a list of values with the lookup wizard.
When I add a record I obviously want to be able to populate this field by picking from a list of values but when I later edit the record I want the user to be able to see the original value but not change it. In other words in edit mode this field is display only but not editable.
How can I do this? If I change the field to read only in the visual editor it changes it for both ADD and EDIT mode and my lookup pick list disappears.
Thanks,
JP.


Solved by editing sql query and adding a field duplicating the required column and setting the duplicate to read only on the edit page and removing duplicate from all other pages.
JP.

O
OLDmrcaseyman 3/14/2009

Thank you for posting your solution! I just never thought of doing it that way and now I will!