help autogenerate id w/ only my combobox

[pesmearga10]

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



and here is the code for the add new command

[Nightwalker83]

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