The current value - This.Value.
The typed value - This.DisplayValue
>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
>>>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.
--sb--