You should not have the same table in the RowSource of a combo.
>Hi,
>
>I've got a need to populate a combobox with a list of values currently contained in a give field of the current table. I've got it populating them, but when an item is selected in the combo box the record changes to that record. How can I just select the value and add it to the current record? Also, I need to give the user the option entering an item not currently contained in the list.
>
>Thanks,
>
>Dennis
- Jayesh