>>>>> you just made a mistake typing Listbox.RowSource in Property Sheet. So, open Form Designer and retype it. If you are really interested to know beforehand what you really typed, then you can open SCX file manually and read record #4.
>>>>>>Third, when you will type in, look at my previous replies how to do it right (it should retain alias).
>>>>>
>>>>>Ed with all this done, correctly I believe, I cannot get the fields of my choice to show up on the listbox rather it defaults to sequential order.
>>>>
>>>>Listbox shows fields in exact order as you specify in List.Rowsource, i.e. if List.RowSource="table1.field3,field2,field10", then you will see field3 as first column, field2 as second, field10 as third, etc.
>>>
>>>Yeah, that's what I thought but the monkey wrench here is that
>>>the table I use is a new temp file created every time with the SAME alias called 'somerecs' Hence, my code:
>>>{tmpfil='tmp'+sys(2)+'.dbf'
>>>use &tmpfil alias somerecs
>>>sele somerecs }
>>>
>>>then the field phrase error message appears.
>>
>>Timothy, I hope you either maintain the same field names or at least reset Rowsource to new field names. BTW, you never dare to type here what's typed in your 'Rowsource' initially.
>
>In property sheet the rowsource line reads:
>somerecs.lname,dob,ss_num
>The rowsource type =Fields and of course the file struct is the same.

Ok, let's separate the problems. When you start the form, do you really see lname as first column, dob as second and ss_num as third. Is this Ok for you?