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
Re: help autogenerate id w/ only my combobox
Have a look in the Database development FAQ I think what your are asking might be covered in one (or more) of the topics.