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