Eric,

Then I think you are going to have to add some special coding to do this. I'd tackle it by a using an array property of the cbo as it's RowSource. Select from your current RowSource into the array and then add the currently bound row of the table into the array and Requery(). You might want to actually use two arrays, one for the select and one for the RowSource so that you don't have to keep hotting the lookup table all the time.

>No. In this case, I am not adding the new value in the list. There are some predefined clients but if the user enter another value, I don't save it in the client table. So, when this occurs, the client name comes from my main table, not from the lookup table.