>>>>>>Hmmm. Controlsource? Know what I often do to figure out these things? Run the a listbox Builder, spec it as required, and the reverse-engineer the result.
>>>>>
>>>>>I have run the builder but still same result. I have the file indexed but the start of the file always shows up!
>>>>I read the whole thread and everything seem ok. But one thing with refresh, is the table getting to the first rec is a child table ?
>>>
>>>Cetin, how can I find this out?
>>Open the DE and check for relations. If that table is related as a child, then some code in refresh might pulling it to the first rec.
>>Cetin
>I have no DE. Just rowsource and rowsourcetype=fields.
Timothy, may i guess what you can do?
Throw away all Listbox.Refresh() and Listbox.Requery() and issue:
Thisform.List1.Value=Table1.Field1
assuming that Table1.Field1 is list.rowsource
Edward Pikman
Independent Consultant