Results 1 to 3 of 3
  1. #1
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Morden, Surrey, United Kingdom
    Posts
    1,838
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Closing user forms (WinNT, W97)

    This is probably a silly question, but here goes anyway - how do I close a user form?!

    I have a form that runs on creating a new doc from the template, and once I have the info stored in variables I want to close it before going on, because I can't get it to hide! My original code said 'me.hide, [run subs]' but the form doesn't hide, it just sits there, so I thought I'd try closing it and see if it goes away then - but I can't work out how to close it!

    Someone please help! <img src=/S/grovel.gif border=0 alt=grovel width=31 height=23>
    Beryl M


  2. #2
    Plutonium Lounger
    Join Date
    Nov 2001
    Posts
    10,550
    Thanks
    0
    Thanked 7 Times in 7 Posts

    Re: Closing user forms (WinNT, W97)

    Does <pre>Unload frmName</pre>

    do what you want?

    Or maybe you just need to add <pre>Application.ScreenRefresh</pre>

    after Me.Hide.

    StuartR

  3. #3
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Morden, Surrey, United Kingdom
    Posts
    1,838
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: Closing user forms (WinNT, W97)

    Thanks, Stuart - the screen refresh was the one that did it!

    <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>
    Beryl M


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •