>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?
>
>All I see is lname in the listbox, nothing else. :(
Listbox.ColumnCount=3
How did you know that you have wrong column sequence, seeing just one column?
Edward Pikman
Independent Consultant