Using DBCombo

[David Laplante]

I have a DataControl to populate a DBCombo wich gets all salutations (M., Mme.,...) from my Client table. The recordset is:

SELECT Client_Salutation, Count(Client_No) AS CountOfClient_No
FROM Client
WHERE Client_No = " & DataClient.Recordset!Client_No
GROUP BY Client_Salutation
ORDER BY Client_Salutation

so my DBCombo shows the right salutation depending on the client shown in my form(using DataClient).

All of this works fine and I can change the salutation of a client by selecting one from the list BUT! I can't add a salutation by typing it in the DBCombo... I get :"Item not found in this collection"

Any of you know why? Is it a property that I'm too blind to see?

I have done this type of thing several times in Ms-Access and it worked fine...

[This message has been edited by David Laplante (edited 11-08-1999).]

[David Laplante]

Please help me...