Set the combo's Style property to dropdown combo. 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.
>I have a combobox on a form where:
>
>ControlSource is Table_A.Material
>RowSourceType is 6-Fields
>RowSource is Table_B.Code
>
>I want the user to be able to add in a new item (not in already in Table_B)and to have that item added to Table B.
>How can I do that?
>
>Thanks in advance
>Raymond Larche
.·*´¨)
.·`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"