Access 97 automatically creating drop down lists

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Phil Longworth

    #1

    Access 97 automatically creating drop down lists

    Im very new to Access 97 and Im sure I should be able to do this but
    cant work out how.
    Im bulding a database for my stamp collection. I have two tables; one
    with details of all the individual stamps, and one with details of
    covers/envelopes the stamps are fixed to. Each indivdual stamp has a
    specific reference number (not an auto-number). Rather than manually
    enter the reference number into my 'covers/envelopes' table I want
    Access to give me a drop down list of the possible ref numbers to
    choose from.
    So if there are five different stamps which have been issued with a
    value of £1.20, and the cover Im cataloguing has a £1.20 stamp on it,
    I can select the ref number from an automatically generated drop down
    list that doesnt have all 250 stamps of all values on it - just the
    two or three £1.20 ones.
    Any suggestions would be welcome.
    Thanks
    Phil
  • John Thomas Smith

    #2
    Re: Access 97 automatically creating drop down lists

    On 4 May 2004 15:03:40 -0700, phil_longworth@ ntlworld.com (Phil
    Longworth) wrote:[color=blue]
    >So if there are five different stamps which have been issued with a
    >value of £1.20, and the cover Im cataloguing has a £1.20 stamp on it,
    >I can select the ref number from an automatically generated drop down
    >list that doesnt have all 250 stamps of all values on it - just the
    >two or three £1.20 ones.[/color]

    Use a Query, with the Distinct option, set the properties of your
    drop down to the Query... you will see only the unique entries


    John Thomas Smith

    http://www.pacifier.com/~jtsmith

    Comment

    • Marlin Snyder

      #3
      Re: Access 97 automatically creating drop down lists

      Hi Phil,

      My suggestion would be to create a query from the table that contains
      the value (Reference Number) you want in the Combo Box. The query may
      contain only the one column, or can contain additional columns, as you
      desire.

      Once you have the query defined, click the 'Groups and Totals' button
      (looks like a wierd shaped E [called a Sigma]), the default behavior
      will be to Group the Columns by each distinct value found. You can
      then save the query.

      Use the Combo Box wizard to insert a new Combo Box on the form, and
      follow the questions asked by the Wizard. When it asks about the
      Table/Query to be used, select Query and then select the Query you
      just created.

      When you run your form, you will have a new Combo (Drop Down) box,
      with each unique Reference Number listed.

      HTH,

      Marlin Snyder

      phil_longworth@ ntlworld.com (Phil Longworth) wrote in message news:<60f68211. 0405041403.376d 943e@posting.go ogle.com>...[color=blue]
      > Im very new to Access 97 and Im sure I should be able to do this but
      > cant work out how.
      > Im bulding a database for my stamp collection. I have two tables; one
      > with details of all the individual stamps, and one with details of
      > covers/envelopes the stamps are fixed to. Each indivdual stamp has a
      > specific reference number (not an auto-number). Rather than manually
      > enter the reference number into my 'covers/envelopes' table I want
      > Access to give me a drop down list of the possible ref numbers to
      > choose from.
      > So if there are five different stamps which have been issued with a
      > value of £1.20, and the cover Im cataloguing has a £1.20 stamp on it,
      > I can select the ref number from an automatically generated drop down
      > list that doesnt have all 250 stamps of all values on it - just the
      > two or three £1.20 ones.
      > Any suggestions would be welcome.
      > Thanks
      > Phil[/color]

      Comment

      Working...