Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Cancelling the opening of a form?

Discussion in 'Information Technology' started by Maury Markowitz, Jul 28, 2006.

  1. Maury Markowitz

    Maury Markowitz
    Expand Collapse
    Guest

    I'm sure this is an easy one: I have a handler in my Form_Open that checks
    for valid inputs. In the case of invalid ones, I'd like to put up an error,
    and then NOT open the form.

    DoCmd.Close closes the entire app, I assume because the form is not yet
    open. Is there a trick to this?

    Maury
     
  2. Loading...


  3. Douglas J Steele

    Douglas J Steele
    Expand Collapse
    Guest

    Simply put Cancel = True in the form's Open event if you don't want it to
    open.

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no e-mails, please!)


    "Maury Markowitz" <MauryMarkowitz@discussions.microsoft.com> wrote in
    message news:6E2B9C62-E37D-4D35-9F55-E8B810ABB345@microsoft.com...
    > I'm sure this is an easy one: I have a handler in my Form_Open that checks
    > for valid inputs. In the case of invalid ones, I'd like to put up an

    error,
    > and then NOT open the form.
    >
    > DoCmd.Close closes the entire app, I assume because the form is not yet
    > open. Is there a trick to this?
    >
    > Maury
     
  4. Maury Markowitz

    Maury Markowitz
    Expand Collapse
    Guest

    "Douglas J Steele" wrote:

    > Simply put Cancel = True in the form's Open event if you don't want it to
    > open.


    Thanks, I knew it would be simple.

    Maury
     

Share This Page