>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