Listbox problem

[mjs]

I have a listbox that is bound to a table and set to multi-select. I also have a button that I called "Generate Code". What I want to do is to be able to select multiple items and generate a code based on the first selected item ID with 3 random letters once I click on the button - "Generate Code" and save the code on the selected items CODE field on the table.

Here's the table fields:

ID
Name
Code

Any suggestion?

Thanks

 

[ezfriend]

Response to your other threads.

http://www.access-programmers.co.uk/forums/showthread.php?t=161325