Welcome to SPN

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

Sign Up Now!

combo box question

Discussion in 'Information Technology' started by David, Oct 29, 2005.

  1. David

    David
    Expand Collapse
    Guest

    Hi

    I have a form with a combo box that shows data from a field in table1 and
    inserts into table 2. My question is there are duplicates in table 1 so the
    combo box shows duplicates. Is there a way to just show single entries.

    Thanks,
    David
     
  2. Loading...


  3. Ken Snell [MVP]

    Ken Snell [MVP]
    Expand Collapse
    Guest

    Add the word DISTINCT between the SELECT word and the first field name in
    the combo box's Row Source query.

    SELECT DISTINCT FieldName1, ....

    --

    Ken Snell
    <MS ACCESS MVP>

    "David" <dfizer@rochester.rr.com> wrote in message
    news:szz8f.28249$Bv6.26235@twister.nyroc.rr.com...
    > Hi
    >
    > I have a form with a combo box that shows data from a field in table1 and
    > inserts into table 2. My question is there are duplicates in table 1 so
    > the combo box shows duplicates. Is there a way to just show single
    > entries.
    >
    > Thanks,
    > David
    >
     
  4. David

    David
    Expand Collapse
    Guest

    Thank you Ken



    "Ken Snell [MVP]" <kthsneisllis9@ncoomcastt.renaetl> wrote in message
    news:OcSWLYC3FHA.3872@TK2MSFTNGP09.phx.gbl...
    > Add the word DISTINCT between the SELECT word and the first field name in
    > the combo box's Row Source query.
    >
    > SELECT DISTINCT FieldName1, ....
    >
    > --
    >
    > Ken Snell
    > <MS ACCESS MVP>
    >
    > "David" <dfizer@rochester.rr.com> wrote in message
    > news:szz8f.28249$Bv6.26235@twister.nyroc.rr.com...
    >> Hi
    >>
    >> I have a form with a combo box that shows data from a field in table1 and
    >> inserts into table 2. My question is there are duplicates in table 1 so
    >> the combo box shows duplicates. Is there a way to just show single
    >> entries.
    >>
    >> Thanks,
    >> David
    >>

    >
    >
     

Share This Page