Download my Combo class. All you have to do is populate a few properties and create a SQL statement to populate the combo. The rest of your needs will be taken care of. Code included in the class.

>Hi all:
>
>I currently have a drop-down combobox with the RowSourcetype set to Value and the Rowsource with values (Name1,Name2,Name3).
>
>In the event that a user's desired choice is not existing in the drop-down combo, I would like to allow the user to enter a value, then add it to the drop-down combo permanently. How can this be achieved.
>
>Thank you for your guidance.
>
>- Ravi