DataBase Problem

[HeSaidJoe]

ok..I use one form to show pictures and another to add and delete pictures.
When I delete all the pictures and go back to the view form I still see the last picture that was displayed but I shouldn't see any because I have deleted all the pictures.
After delete I've even gone so far as to do another sql
and then reload another recordset * from pictures so in fact at this point it should have nothing in it if I've
deleted the last picture.


When I use this code
frmOne.visible=false
frmTwo.visible = true

does this code not trigger the activate and load events of
frmTwo???

Since in activate and load I have a Select * from pictures and a if eof and bof go...bla bla it should not show a picture...

when I shut the app down and restart it does what it should and not show a picture.

What is the scoop on this crap..I've wasted a week on this stupid go round and round

[LG]

Do you refresh recordset after delete?

[HeSaidJoe]

yes...first I refreshed the recordset and then as
an alternataive I used a new sql selection * form the table and that should only give what is left...
surprise...it still shows a picture when nothing is in the
image file or in the database.

[mattbrown]

You also need to clear the picture box as the application makes a copy of the picture in memory rather than loading it from it's source each time.

use
[pictureboxname].cls

Regards