Welcome to SPN

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

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

KBV - combo box

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

  1. KBV

    Expand Collapse

    What's the difference between a list and a combo box?

    Can you select the row source to be the col in a table or does it have to be
    written in sql?

  2. OP
    Albert D.Kallal

    Albert D.Kallal
    Expand Collapse

    "KBV" <KBV@discussions.microsoft.com> wrote in message
    > What's the difference between a list and a combo box?

    A combo box is a drop down box that presents the user with a list of values
    to select.

    In MOST cases, the results of a combo box selected can be bound to a field
    in the database. So, the combo box can store a customer id, but "display"
    the customer name (for ease of reading and selection).

    > Can you select the row source to be the col in a table or does it have to
    > be
    > written in sql?

    It does NOT HAVE to be a query. And, yes, you can use a col from a table, or
    query...your choice.

    The combo box can be based on a table, but a query is preferred, as you can
    then select what columns, and MORE importantly, set the sort order of the
    data (which you can't do when you use a table for the source of the combo).

    >the difference between a list and a combo box?

    A list box can be bound to a field on a form, but MOST of the time you would
    use a combo box. A listbox can also return MULTIPLE values (but, when you do
    this, the list box can't be bound to a field on the form. What this means
    that is MOST of the time, a list box is a UN-BOUND control. (the listbox
    will get its data from a table, or query just like a combo box, but when you
    turn on the multi-selections in a listbox, you can NOT bind the listbox to a
    field on the form (you can't stuff multiple values into a field).

    It thus turns out that VERY often, a listbox is NOT bound to a field. Here
    is some screen shots, and you will note that both the listboxes, and combo
    boxes are NOT bound to any data fields, but are ONLY FOR user input and
    selection of data.


    So, some times we will bind a listbox to a field on a form, but for the most
    part, in those cases, a combo box is preferred, and takes up less room. A
    listbox is ideal when you want the user to select a "few" items from a small
    list of choices for a report. (so, listbox is not much use for storing

    Here is some more screen shots, and the first one does show the use of a


    Note in the above, how the first listbox example displays the data as a
    grid....again, this is use for listbox...

    Albert D. Kallal (Access MVP)
    Edmonton, Alberta Canada
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     

Share This Page