Thanks for that.
I experemented and finaly found the easyest way was:

select distinct [fields];
from [database];
where [filter required];
order by [selected field];
into array thisform.myarray

However what took me a while to work out was how the value is different between combobox and listbox.

I have a aquired copy of VP6 without help files and am relying on my old Foxpro 2.6 manuals and VP3 help files.

Regards
Brian