Welcome to SPN

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

Sign Up Now!

What is the field list option for when creating a combo box?

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

  1. trainer07

    trainer07
    Expand Collapse
    Guest

    If I want to manually make a field in table into a combo box, I normally go
    into design view and go to the Lookup tab in the Field Properties section and
    choose Combo Box from the Display Field section, Value List from the Row
    Source Type and then I type in my values in the Row Source section. My
    question is, what is the field list used for in the Row Source Type section?
     
  2. Loading...


  3. Danny J. Lesandrini

    Danny J. Lesandrini
    Expand Collapse
    Guest

    I only learned this recently, and I can't see any use for it, except to build
    relationship diagrams.

    Select Field list and supply a table name as the row source. The combo
    box will display a list of fields in that table.
    --

    Danny J. Lesandrini
    dlesandrini@hotmail.com
    http://amazecreations.com/datafast


    "trainer07" <trainer07@discussions.microsoft.com> wrote ...
    > If I want to manually make a field in table into a combo box, I normally go
    > into design view and go to the Lookup tab in the Field Properties section and
    > choose Combo Box from the Display Field section, Value List from the Row
    > Source Type and then I type in my values in the Row Source section. My
    > question is, what is the field list used for in the Row Source Type section?
     
  4. Douglas J. Steele

    Douglas J. Steele
    Expand Collapse
    Guest

    Danny's already answered your question.

    I just wanted to mention that most of us recommend very strongly against
    creating lookup fields in tables. You should never be working directly with
    tables: you should always use a form. With that approach, it makes
    absolutely no sense to use a lookup field in a table. Take a look at
    http://www.mvps.org/access/lookupfields.htm for some of the reasons for our
    recommendation.

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


    "trainer07" <trainer07@discussions.microsoft.com> wrote in message
    news:84E8270F-1CA7-4974-9A86-2CFD82D6DB50@microsoft.com...
    > If I want to manually make a field in table into a combo box, I normally
    > go
    > into design view and go to the Lookup tab in the Field Properties section
    > and
    > choose Combo Box from the Display Field section, Value List from the Row
    > Source Type and then I type in my values in the Row Source section. My
    > question is, what is the field list used for in the Row Source Type
    > section?
     

Share This Page