>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.
The second thought: instead of RowSourceType=3 && SQL set it to be alias. The cursor should be updatable and SET DELETE should be ON. In my class I used value as a RowSourceType, so it was easy. You can also try array as a RecordSource.
If it's not broken, fix it until it is.
My Blog