>Yes, it does nothing.
>
>>>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
>>
>>Peter
>>
>>Did you try a .lstYourListBox.Requery() at initialisation?

Beats me then. I'm working on a form with practically the same and it works fine, even without the .refresh().

All I can say then is the obvious: are you sure the 'DamageExtent table is open before setfocus?