Welcome to SPN

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

Sign Up Now!

Enter parameter value

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

  1. an

    an
    Expand Collapse
    Guest

    Hi!
    I have one form based in conditional query.
    When open the form with "Enter parameter value" to write option, if we click
    on Cancel boutton, open empty form based in query.

    What is we do to close this form, and standby in last position, please?

    Tnahks in advance.
    an
     
  2. Loading...


  3. Ofer Cohen

    Ofer Cohen
    Expand Collapse
    Guest

    On the form load event you can write the code, to check if the form has any
    records, if not the form will be closed

    If Me.RecordsetClone.RecordCount = 0 Then
    DoCmd.Close acForm, "FormName"
    End If

    --
    Good Luck
    BS"D


    "an" wrote:

    > Hi!
    > I have one form based in conditional query.
    > When open the form with "Enter parameter value" to write option, if we click
    > on Cancel boutton, open empty form based in query.
    >
    > What is we do to close this form, and standby in last position, please?
    >
    > Tnahks in advance.
    > an
    >
     
  4. an

    an
    Expand Collapse
    Guest

    Thanks for your reply

    Sorry.
    I go to try to be more explicit.

    I have one unbound MainForm with two subforms: SubForm1 based on Q_SubForm1
    and SubForm2 based on Q_SubForm2.
    When queries runs, each one makes the one asks.
    In this moment, if we click in Cancel, ignores it and it opens in the same o
    MainForm with Subforms.
    It would like that this did not happen.

    an

    "Ofer Cohen" wrote:

    > On the form load event you can write the code, to check if the form has any
    > records, if not the form will be closed
    >
    > If Me.RecordsetClone.RecordCount = 0 Then
    > DoCmd.Close acForm, "FormName"
    > End If
    >
    > --
    > Good Luck
    > BS"D
    >
    >
    > "an" wrote:
    >
    > > Hi!
    > > I have one form based in conditional query.
    > > When open the form with "Enter parameter value" to write option, if we click
    > > on Cancel boutton, open empty form based in query.
    > >
    > > What is we do to close this form, and standby in last position, please?
    > >
    > > Tnahks in advance.
    > > an
    > >
     
  5. an

    an
    Expand Collapse
    Guest

    Sorry.

    The "form" that I mention is of the proper Access. It does not have access
    to button “OKâ€â€¦
    What I would liked is to be able to substitute the text in the heading
    “Enter to parameter valueâ€.

    Thanks.
    an

    "Ofer Cohen" wrote:

    > On the form load event you can write the code, to check if the form has any
    > records, if not the form will be closed
    >
    > If Me.RecordsetClone.RecordCount = 0 Then
    > DoCmd.Close acForm, "FormName"
    > End If
    >
    > --
    > Good Luck
    > BS"D
    >
    >
    > "an" wrote:
    >
    > > Hi!
    > > I have one form based in conditional query.
    > > When open the form with "Enter parameter value" to write option, if we click
    > > on Cancel boutton, open empty form based in query.
    > >
    > > What is we do to close this form, and standby in last position, please?
    > >
    > > Tnahks in advance.
    > > an
    > >
     

Share This Page