Thanks Jeff that worked great! Not sure I understand why.

>>I am trying to populate a listbox on a form with the results of an SQL select statement.
>>
>>thisform.list1.rowsourcetype=3 &&SQL statement
>>thisform.list1.rowsource="select * from transact where trans_id='IPC' into cursor tmp"
>>
>>When this code is run the results briefly show up in the listbox then the message "filter cleared" appears (as a wait window) and the listbox is grayed out. I've done this many times and have never experienced this can someone please help.
>>
>>Thanks,
>>David
>
>Try the NOFILTER clause. Select * from whatever NOFILTER.
>
>You may have a small data set and Fox is just creating a filter view of you original data.
>
>HTH
>Jeff