Closing a form

  • Thread starter Thread starter kevin
  • Start date Start date
K

kevin

Hi

I call a form in which i select data from a list box. I
hit a command button in the form and it opens a file based
on the lost box data.

How do I close the form?

At the minute i just say
With UserForm1
.Hide
End With

This works but the next time i call the form and try to
enter some data in a list box i get an error saying "could
not complete the operation dueto error 800a01a8". I say
ok, call the form again and it will work fine ie it work 1
out of every 2 times
any ideas thanks
 
Hi

Unload Me
is the magic word. Make sure you're finished reading and passing everything
before this, all Form data and settings is lost on Unload.
 
thanks Harold
-----Original Message-----
Hi

Unload Me
is the magic word. Make sure you're finished reading and passing everything
before this, all Form data and settings is lost on Unload.

--
HTH. Best wishes Harald
Followup to newsgroup only please

"kevin" <[email protected]> skrev i melding


.
Click to expand...
 
Back
Top