Adding another one string to the list of strings from table or query in Combo Box

[Sharkky]

I'm working with MS Access
I want to make such thing with combo box: it's necessary to make a choice from a set of values what are already written into table, but if it's needed to add another one value to the table it should be done through the special string in combo box. Choosing of this string should start an add dialog.

So the questions:

1. To use the set of values from a table or a query it's required to set "RowSourceType" property of combo box to "Table/query", in this case SQL string should be assigned to "RowSource" property. How can I add another one string to the list of combo box, except values from the table, in this case??? And what should be another case, if it's impossible to add string in this case

2. How to process choosing from combo box. List Box has ListIndex property, do Combo Box have something similar?

If somebody knows help me please!

[antares686]

Create an item in the table named Add New. Then in the on change event of the Combo box check to see if the Add New value is selected (not default) and if so then pop the other dialog.

[Sharkky]

Ok, thanks