generating unique IDs from criteria?

[hi there]

hello all,

i'm try to automate the task of assigning an unique ID based on selection criteria from a combo box. for example i have a combo box that list values: Ants, Bats, and Cats. what i would like to do is have the user select one of the values from the combo box and then access automatically assigns that record an unique ID (in sequential order) with an extension at the end of the ID that corresponds to the first letter of the value selected from the combo box. so for the 23rd ant record the ID would be: 023A. can anyone suggest some VBA code to do this and tell me where to place the code?

thanks everyone

 

[Travis]

You will find examples on how to do this by Searching for "Unique" using this forumns Search Feature.

Happy Hunting.

 

[hi there]

unique ID help

hi all,

i tried searching the forum using "unique" as my keyword, but i couldn't find an example directly related to this. could someone give me a little tutorial or suggest some sample code (and where to place this code) on how to do this.

thanks everyone

 

[ghudson]

This post looks interesting for a start to your quest...

http://board.quicktechusa.com/cgi-bin/ultimatebb.cgi?ubb=get_topic;f=1;t=003227

HTH