Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Aug 2005
    Posts
    45
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Combo box (2003)

    Hello,

    I am creating a table in access. I want one of the fields in the table to list previous entries as well as be able to put new information. currently I created a combo box with a query, but the query list a name multiple times instead of one only. Any help would be great. Thanks.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Combo box (2003)

    Open the query in design view.
    Click in an empty part of the upper half of the query design window.
    Activate the Properties window. It should be titled Query Properties.
    Set the Unique Values property to Yes.
    Close and save the query.

  3. #3
    Lounger
    Join Date
    Aug 2005
    Posts
    45
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Combo box (2003)

    Thanks Hans.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •