Rowsource is a table

Rowsource should be set up like this if RowSourceType is 6-Fields:

Alias.Field1,Field2

ControlSource is a memory variable init 0

What do you mean by that? You mean that it is Bound to a public variable? Or do you mean that it is bound to a form property.

You also did not tell me what the bound column of the list box is and what its data type is. If the BoundColumn of the list contains numeric data, you must set the list's BoundTo property to true.

This is just a basic list box control in a form using the form designer...I use them all the time, but never trying to default to a particular record. Usually I just set value to 1 so the bar is highlighted on the first record.

Something else must be going on here because it really is as simple as locating the record you want in the listbox's RowSource and setting the value of the ListBox.