Hi Rip...

Contrary to Ed's advice here, there is no real complication to using the controlsource property. It is a matter of understanding how the control works.<s>...

One question that should be asked is what the RowsourceType Property is. Try these steps:

1. When the value of the underlying object changes to a new value, check to see if the value is in the RowSource of the combo.
2. If it is not, add it
3. Once the new value has been added, invoke the Requery() of the combobox.

Because the combo is bound, it should be set at the correct value automatically. Obviously, if the value is already present, you won't need to do anything....


>I have a combobox with a controlsource property set to a property of another object, in this case my application object. It has a style property of 0 (combo). The problem is when I change the value of the application object's property that is the control source of the combobox the combobox won't display that value unless it is in the rowsource of the combobox. Any ideas?
>
>Thanks