1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

How to make unique ID for specific items in Drop Down box

Discussion in 'MS Access' started by JSSherm, Jul 2, 2008.

  1. JSSherm

    JSSherm New Member

    Jul 2, 2008
    Likes Received:
    Trophy Points:
    Hi, I'm brand new to MS ACCESS and I am using MS ACCESS 2007. I would like to make a drop down list of different animal species for an animal shelter database. The list is no problem but I would like to have a unique ID# appear when a specific species is selected. For example if someone clicks DOG then a ID# would appear that begins with the letter "D", CAT would have an ID# that begins with "C", Bovine=ID# begining with "B", etc. Then I would like to use the unique ID# for a listing of each species in a Report.

    Is any of this possible? I'm thinking this is a VBA script but not sure if it might be a SLQ script? As a newbie I can create a table with a progressive ID# list but cannot figure out how to give each item a unique ID#.

    John S.

Share This Page