David Laplante
Nov 8th, 1999, 03:45 AM
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).]
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).]