Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Oct 2004
    Location
    Minnesota, USA
    Posts
    144
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Opening Form Hidden (Access 2000/2003)

    I have a form with controls I access as conditions in a macro. Most of the time, the user does not need to see the form, but there are times they do.

    How can I open a form in the background, invisible to the user? I know how to do it with controls, and how to make them visible if X happens. I'm not sure how to do it with a form. Maybe I can't.

    Thanks!

    Nancy

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 18 Times in 18 Posts

    Re: Opening Form Hidden (Access 2000/2003)

    The OpenForm action in a macro and the DoCmd.OpenForm method in VBA have an argument WindowMode. This can be set to Hidden (acHidden in VBA) to open the form invisible.

    To make an already open form visible or invisible, set its Visible property. In a macro, select the SetValue action, set Item to Forms!FormName.Visible (where FormName is the name of your form) and the Expression to True or False as needed. In VBA, use

    Forms!FormName.Visible = True

    (or False). Note: this will only work for open forms.

  3. #3
    2 Star Lounger
    Join Date
    Oct 2004
    Location
    Minnesota, USA
    Posts
    144
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Opening Form Hidden (Access 2000/2003)

    Perfect! I figured it was something simple.

    I appreciate your helpful and fast answers.

    Nancy

Posting Permissions

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