This is something I would recommend against doing.

I did this a couple years ago for a customer and you wouldn't believe the "junk" that was added to the table..........poor spelling, all lower case, all uppercase, duplicate entries due to typos, etc.

What I ended up doing is supervisor password protecting a maintenance form for doing things like this. It was inconvenient at first, until they got most of the entries they really needed.

>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