1. We have moved from vBulletin to XenForo and you are viewing the site in the middle of the move. Though the functional aspect of everything is working fine, we are still working on other changes including the new design on Xenforo.
    Dismiss Notice

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

    Joined:
    Jul 2, 2008
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    0
    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#.

    Thanks,
    John S.
     

Share This Page