help autogenerate id w/ only my combobox

http://i22.photobucket.com/albums/b303/mikelim/pm.png

I need to have an auto generated product code.

In my example I have PROD008 as my last element. So, I need in my combobox just PROD009 when clicking add new command. You can see in my product code combobox that when dropped down, there is already a list of the records saved.

Here is the code of the product code combobox

http://i22.photobucket.com/albums/b3...lim/pmcode.png

and here is the code for the add new command

http://i22.photobucket.com/albums/b3...im/pmcode1.png

Have a look in the Database development FAQ I think what your are asking might be covered in one (or more) of the topics.