Hi Frank,

It's a listbox, not a dropdown.

>Hi Peter,
>
>is this a listbox or a dropdown list/combo box? I ask because I've seen this behaviour with dropdown lists/combos when the item you want displayed is not the first item specified in the rowsource.
>
>>A listbox with
>>
>>RowsourceType = 6
>>Rowsource = 'DamageExtent.ExtentCode,ExtentText,ExtentId'
>>
>>does not show data until the listbox receives the focus.
>>
>>I set Listindex to 1 in the Requery and Refresh method, all to no avail.
>>
>>What's missing?
>>
>>BTW, happy new year everybody - and TIA