Go4Expert

Go4Expert (http://www.go4expert.com/)
-   MS Access (http://www.go4expert.com/forums/ms-access-forum/)
-   -   How to make unique ID for specific items in Drop Down box (http://www.go4expert.com/forums/unique-id-specific-items-drop-box-t11793/)

JSSherm 2Jul2008 20:03

How to make unique ID for specific items in Drop Down box
 
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.


All times are GMT +5.5. The time now is 03:59.