Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2007
    Stalybridge, Manchester

    Unanswered: Close and Open Forms

    Is it possible to close and re-open the same form without the user noticing?

    I want to try this as I'm think of ways to reset what the form shows once submit button has been clicked.

  2. #2
    Join Date
    May 2005
    Nevada, USA
    Provided Answers: 6
    You can do it, but I'd probably look at other options. What do you mean by "reset what the form shows"? You can simply go to a new record, clear the form fields, etc.

  3. #3
    Join Date
    Feb 2004


    If you close and reopen, it may be noticeable depending on the pc they are running.

    If you are doing data entry and do not want them to be able to access what they just input, then you may want to consider a subform.

    You want to try having a subform and upon clicking the button requerying the subform.
    You know, I'm sick of following my dreams, man. I'm just going to ask where they're going and hook up with 'em later

  4. #4
    Join Date
    Nov 2007
    Adelaide, South Australia
    You could turn off screen echoing while you close and re-open the form. Just don't forget to turn it back on again.

    I would be resetting the form by other means though.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!

    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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