• Combo box (2003)

    Home » Forums » AskWoody support » Productivity software by function » MS Access and database help » Combo box (2003)

    Author
    Topic
    WSaaaofpmch
    AskWoody Lounger
    August 25, 2005 at 2:02 am #423370

    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.

    Reply | Quote
    Viewing 1 reply thread
    Author
    Replies
    • WSHansV
      AskWoody Lounger
      August 25, 2005 at 5:32 am #968628

      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.

      Reply | Quote
    • WSaaaofpmch
      AskWoody Lounger
      August 25, 2005 at 1:34 pm #968722

      Thanks Hans.

      Reply | Quote
    Viewing 1 reply thread
    Reply To: Combo box (2003)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information:




DON'T MISS OUT!
Subscribe to the Free Newsletter
We promise not to spam you. Unsubscribe at any time.
Invalid email address

View the Forum

  • Recent Replies
  • My Replies
  • My Active Topics
  • New Posts in the Last day
  • Private Messages
  • Knowledge Base
  • How to use the Forums
  • All Forums

    • Recent Topics

    My Profile

    May 2025
    S M T W T F S
     123
    45678910
    11121314151617
    18192021222324
    25262728293031

    Remembering Woody

     

    Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.

    Mastodon profile for DefConPatch
    Mastodon profile for AskWoody

     

    Home • About • FAQ • Posts & Privacy • Forums • My Account
    Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts

    Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.