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