Sergey

Please enlighten me. How does this check whether the input value already exists in the look-up, before deciding to write the new value to the table? As I read it, it only checks the current value of the combo. But then again, sometimes I'm dyslexic at reading others' code :-)

Terry

>>Try

* Combo Valid
>>IF NOT EMPTY( This.DisplayValue )  ;
>>		AND NOT (ALLTRIM(This.DisplayValue) == ALLTRIM(This.Value))
>>	INSERT INTO mytable VALUES (This.DisplayValue)
>>	This.Value = This.DisplayValue
>>	THIS.Requery()
>>ENDIF
>>

>>>
>
>Thank you very much, Sergey. I will try your approach.