>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

Do you want to type it in the comboboxbox itself?
If not, add the new record to Table B (using INSERT INTO or APPEND BLANK and REPLACE - whatever)

combobox.REQUERY()
combobox.REFRESH()

If you want to type it in the combo, then do as Tracy says.

Also, I would rather use RowSourceType 2-Alias
This may help you to avoid some unexpected problems like in message#854229