Neil,
Move your select statemen into the Load of the form and use array propertry.
>Erik
>
>I now have the select statement in the init event on my form:
>
>
>SELECT DISTINCT reports.descrip ;
>FROM ("U:\Data\Reports.dbf") ;
>INTO ARRAY neil
>
>WITH thisform.list1
> .RowSource = 5
> .RowSource = 'neil'
> .ColumnCount = 1
>ENDWITH
>
>
>But nothing shows in my list box. Is there any reason for this?
>
>Many Thanks
--sb--