Thanks Cetin,
I think I have it working now. I have selt the row source type to 3 - SQL Statement and then set the row source to:
Select mainstnd.key2 from "U:\Data\Mainstnd.dbf"
The values are now shown in the list which is great. But what it also does is open up a temp tables with the same values. How can I stop the showing of the temp table or cursor?
Many Thanks
Neil Lewis
IT R&D Manager
Velmore Ltd