>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
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison