Re: Program still running after UNLOAD

Thanks Bob. Oddly enough, when I returned to my project this morning I
didn't have this problem. I guess in working with all my forms yesterday, I
probably had one in the background that I didn't see. Any suggestions I
could use to close any open forms? Something like FOR EACH form in
project...unload. Would I put this in a Terminate routine?

Barry

"Bob Butler" <noway@xxxxxxxxxxx> wrote in message
news:%23054vCY9HHA.4712@xxxxxxxxxxxxxxxxxxxxxxx
"BCS" <nospam@xxxxxxxxxxx> wrote in message
news:46e85242$0$6431$4c368faf@xxxxxxxxxxxxxxxxx
I've written several VB apps as a novice, but have encountered a new
issue. I'm writing a simple data entry screen that retrieves and writes
data back to an Access 2000 database. When I click Cancel to close my
app, as with all my previous apps I run a routine that closes my database
connection and any recordsets. Next, I simply unload the form. The form
does indeed unload but my VB Design window still shows the app running
and I have to click the End button on the toolbar to stop it. All my
previous apps never get running like this one. Any ideas what is going on
or what I can do to correct the problem?

Chances are you have another form loaded. Instead of clicking END click
PAUSE and in the immediate window enter this:

? forms.count

if that is anything but zero try:

for each f in forms:?f.name:next

then add code to unload those forms when done.

If there aren't any forms loaded post back for other things to check for



.

Loading