User Input Value List How Do I Edit The List?

[SPT]

I have a field which users can either input a NEW value which is then added to the list or select from values previously added to the list.

How do I delete or change these values???

Thanks

[Vaughan]

I if the value list is based on the field, manually entering a new value into the field will automagically add it to the value list (since the value list is based on the field's index).

Removing values from a value list based on a field is another matter: the value will only disappear if no records in the database have the value any more. This can easily be accomplished with a find and replace, but it means that a whole heap of records need to be edited.

Summary: if you want the ability to easily add items into a value list, you have to put up with the fact that the value list will include all values in the database inthat field.

[SPT]

Thanks Vaughan,

That did the trick!

Thanks again.