Thanks for pointing that out Marcia and including your example code for a better way to do it. I hadn't even thought of that when he posted his question!
>Hi Tracy.
>
>
When the user types a new value into the textbox portion of the combo that doesn't exist compar the combo's Value to its DisplayValue. If it is not the same add the code to add the value to the table and requery the combo when your done.>
>This is will only work when the BoundColumn is column 1. The best way to make this comparison is to use code like this:
>
>
>IF NOT EMPTY( This.DisplayValue ) AND This.ListIndex = 0
> *** The user has typed something that is not in the list
> APPEND BLANK IN Table_B
> REPLACE MyDescriptiveField WITH This.DisplayValue
> This.Requery()
>ENDIF
>
.·*´¨)
.·`TCH
(..·*
010000110101001101101000011000010111001001110000010011110111001001000010011101010111001101110100
"When the debate is lost, slander becomes the tool of the loser." - Socrates
Vita contingit, Vive cum eo. (Life Happens, Live With it.)
"Life is not measured by the number of breaths we take, but by the moments that take our breath away." -- author unknown
"De omnibus dubitandum"