>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.

How do you delete the items? Do you have set deleted on (which should filter deleted records)? Also I would suggest to look into one of my classes Input classes here in Download section. I used KeyPress method to delete items from the listbox and as I recall, the RowSourceType is value, but you can get the idea.