Viv,

Yup, set the Value property. Key was doing the Requery (funny, I thought it was there five minutes ago...) (Check the thread)

Thanks for the help.

Tim

>Hi,
>
>>But when the focus shifts from the combo box, the DisplayValue goes blank.
>
>Are you setting the Combo's .Value property ?
>
>Regards,
>Viv