Welcome to SPN

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

Sign Up Now!

Default Parameter on form open

Discussion in 'Information Technology' started by msmuzila@gmail.com, Jul 28, 2006.

  1. msmuzila@gmail.com

    msmuzila@gmail.com
    Expand Collapse
    Guest

    i have a form that gets info from a query. The parameter in the query
    is linked to the combo on the form

    [Forms]![Part_Monthly]![Combo36]

    I need a way to have a default value of 1010 when I open the form so
    that it does not ask me for the parameter value.

    Thanks
    Matt
     
  2. Loading...


  3. fredg

    fredg
    Expand Collapse
    Guest

    On 29 May 2006 08:57:00 -0700, msmuzila@gmail.com wrote:

    > i have a form that gets info from a query. The parameter in the query
    > is linked to the combo on the form
    >
    > [Forms]![Part_Monthly]![Combo36]
    >
    > I need a way to have a default value of 1010 when I open the form so
    > that it does not ask me for the parameter value.
    >
    > Thanks
    > Matt


    Is the bound column of the combo box a Number datatype or Text?
    If a Number, try:

    IIf IsNull([forms]![Part_Monthly]![Combo36],1010,
    [forms]![Part_Monthly]![Combo36]

    If it's text use "1010" instead of 1010.

    --
    Fred
    Please respond only to this newsgroup.
    I do not reply to personal e-mail
     
  4. msmuzila@gmail.com

    msmuzila@gmail.com
    Expand Collapse
    Guest

    this is what i put in the crosstab criteria for the parameter

    IIf(IsNull([forms]![Part_Monthly]![Combo36]),1010,[forms]![Part_Monthly]![Combo36])

    when i open my form it still asks me for
    [forms]![Part_Monthly]![Combo36]

    when i hit cancel on this message box, it goes to the correct spot, so
    is there a way to automatically cancel the parameter message box?
     

Share This Page