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