Welcome to SPN

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

Sign Up Now!

Open combo box to specific record

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

  1. Economics

    Economics
    Expand Collapse
    Guest

    i have a combo box on an edit only form that i am using, i would like for
    that combo box to start out on a specific record every time that i open my
    form, anyone have any ideas on how to do this? Thank you in advance.
     
  2. Loading...


  3. KARL DEWEY

    KARL DEWEY
    Expand Collapse
    Guest

    Add a new field to your source data and sort on it descending. Put and "X"
    in the field.

    "Economics" wrote:

    > i have a combo box on an edit only form that i am using, i would like for
    > that combo box to start out on a specific record every time that i open my
    > form, anyone have any ideas on how to do this? Thank you in advance.
     
  4. Rick Brandt

    Rick Brandt
    Expand Collapse
    Guest

    Economics wrote:
    > i have a combo box on an edit only form that i am using, i would like
    > for that combo box to start out on a specific record every time that
    > i open my form, anyone have any ideas on how to do this? Thank you in
    > advance.


    ComboBoxes don't have "records". Do you mean you want its value to default
    to a specific ROW in its RowSource?

    Is this a bound ComboBox? If it's bound then it is going to show whatever
    value the current record has for that field. If it is not bound then just
    set its DefaultValue property to whatever value you want.

    --
    Rick Brandt, Microsoft Access MVP
    Email (as appropriate) to...
    RBrandt at Hunter dot com
     
  5. Economics

    Economics
    Expand Collapse
    Guest

    Im sorry but im not really following you, could you please elaborate on how
    this would work, and the process?

    "KARL DEWEY" wrote:

    > Add a new field to your source data and sort on it descending. Put and "X"
    > in the field.
    >
    > "Economics" wrote:
    >
    > > i have a combo box on an edit only form that i am using, i would like for
    > > that combo box to start out on a specific record every time that i open my
    > > form, anyone have any ideas on how to do this? Thank you in advance.
     
  6. KARL DEWEY

    KARL DEWEY
    Expand Collapse
    Guest

    I say that if your ComboBox record source is a table then add another field
    and place an X in that field for the record you want to display as the
    default.

    Then sort the record source by that field, descending, and your other field
    ascending. The record with the X will always be at the top of the
    display.

    "Economics" wrote:

    > Im sorry but im not really following you, could you please elaborate on how
    > this would work, and the process?
    >
    > "KARL DEWEY" wrote:
    >
    > > Add a new field to your source data and sort on it descending. Put and "X"
    > > in the field.
    > >
    > > "Economics" wrote:
    > >
    > > > i have a combo box on an edit only form that i am using, i would like for
    > > > that combo box to start out on a specific record every time that i open my
    > > > form, anyone have any ideas on how to do this? Thank you in advance.
     

Share This Page