Welcome to SPN

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

Sign Up Now!

option group to query or table

Discussion in 'Information Technology' started by kris, Nov 5, 2005.

  1. kris

    kris
    Expand Collapse
    Guest

    Anyone know the code to associate and update from an option group check box
    to a query check box?
    Option Group: "frame116"
    RUNNING "option121"
    ON-HOLD "option122"
    OFF-HOLD "option123"

    Query "Status"
    field: "RUNNING"
    field: "ON-HOLD"
    field: "OFF-HOLD"
     
  2. Loading...

    Similar Threads Forum Date
    Adoption: Why is it Taboo? Hard Talk Jun 21, 2013
    USA Florida Court Voids Adoption Of Millionaire’s Girlfriend As Sham Breaking News Mar 29, 2013
    Opinion Dog loving babas of Juna Akhada advocate adoption of street dogs Breaking News Jan 21, 2013
    Controversial Only option for fading churches is to again take up evangelization Hard Talk Dec 26, 2012
    Introducing New Functionality: Dislikes Option Announcements Apr 12, 2012

  3. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Fri, 4 Nov 2005 17:30:48 -0800, "kris"
    <kris@discussions.microsoft.com> wrote:

    >Anyone know the code to associate and update from an option group check box
    >to a query check box?
    >Option Group: "frame116"
    >RUNNING "option121"
    >ON-HOLD "option122"
    >OFF-HOLD "option123"
    >
    >Query "Status"
    >field: "RUNNING"
    >field: "ON-HOLD"
    >field: "OFF-HOLD"


    An Option Box (frame116) is a control with a single, numeric value. If
    you're trying to update three fields, it is not the appropriate type
    of control! Could you instead use a rectangle with three bound
    checkboxes, one bound to each of these fields (which I presume are
    True/False fields)? Or, if the three values are mutually exclusive,
    consider changing your table design; have *one* field named Status,
    Integer type, with 1 interpreted as Running, 2 as On-Hold, 3 as
    Off-Hold. Bind the option group control to this field.

    John W. Vinson[MVP]
     
  4. kris

    kris
    Expand Collapse
    Guest

    Hi John,
    Yes I could do the bound check box thing. As a matter of fact I had that
    done at one time. It's just the frame is so quick, ez and it looks good
    giving the form an application look and feel. It's not that big of a deal
    though. I was just wondering. Thank you very much for the reply.

    "John Vinson" wrote:

    > On Fri, 4 Nov 2005 17:30:48 -0800, "kris"
    > <kris@discussions.microsoft.com> wrote:
    >
    > >Anyone know the code to associate and update from an option group check box
    > >to a query check box?
    > >Option Group: "frame116"
    > >RUNNING "option121"
    > >ON-HOLD "option122"
    > >OFF-HOLD "option123"
    > >
    > >Query "Status"
    > >field: "RUNNING"
    > >field: "ON-HOLD"
    > >field: "OFF-HOLD"

    >
    > An Option Box (frame116) is a control with a single, numeric value. If
    > you're trying to update three fields, it is not the appropriate type
    > of control! Could you instead use a rectangle with three bound
    > checkboxes, one bound to each of these fields (which I presume are
    > True/False fields)? Or, if the three values are mutually exclusive,
    > consider changing your table design; have *one* field named Status,
    > Integer type, with 1 interpreted as Running, 2 as On-Hold, 3 as
    > Off-Hold. Bind the option group control to this field.
    >
    > John W. Vinson[MVP]
    >
     

Share This Page