>Hi, Dear All
> I've created a list box use the sql statement as its rowsource. And there is a dblclick event content a delete clause related with one of the sql statement tables. But after the delete clause excuted, and list box requery method excuted also, The list items didn't change, even I add the refresh() into the dblclick(). But the same thing works to insert clause. I don't know why.
> Is there any suggestion about it from all of you! Thanks.


Do you have SET DELETE OFF? Remember that it will reset to ON in a Private Datasession.