Eric,
I never use cbos unless they are set to dropdown list, so I'm not sure if this helps or not. But after updating the RecordSource does explicitly calling the Requery() method of the cbo get the new value into the list?
>I have a small application where the user can fill the field of the table mymaintable. When it comes to the client field, he can either select one of the values from myclienttable.name or enter a new one.
>The combo is set as 2-Alias (I tried 6-field with the same result) and the rowsource is set as myclienttable.name
>
>When the user add a new record, no problem: He can select within myclienttable.name or add manually a new value. When I save in my main table, I replace mymaintable.client with THISFORM.combobox.text that contains the proper value. So far so good.
>
>The problem is that, when I retrieve the record and I want to display it on screen, nothing appears when I take the good value from mymaintable.client and copy it in THISFORM.combobox.value. Unfortunately, I cannot copy it in THISFORM.Combobox.text since it is a readonly property.