Solved Form with event statement not working

[JLB - SA]

Good day all.

The attached is some database code I used as a basis to generate drawing numbers for Projects and Disciples. On stress testing the sequence numbers do generate but not with the desired results.

I am not a programmer and always adapt templates to build applications for work and other.

Hope somebody will be able to assist.

Many thanks

 

[June7]

What are the desired results?

What process do you want to code?

Why did you attach Excel files?

 

[JLB - SA]

I want the backend event in generating drawing number to be refined. I call it a process, perhaps not correct naming convention.

The excel sheets is an indication of what I get and what I do need

Thanks

 

[arnelgp]

I change the code on Form, "Generate Drawing NUmber" (see the code).

 

[JLB - SA]

Thank you very much Arelgp. You are a super star. Cannot tell you how I appreciate this.

All I can say is thank you for your effort and help. Much appreciated.

 

[arnelgp]

ank you for your effort and help

I added another column (Prefix) on your DrawingType combo.

 

[JLB - SA]

I change the code on Form, "Generate Drawing NUmber" (see the code).

Thank you very much

I added another column (Prefix) on your DrawingType combo.

Hi, I can confirm with lots of entries the code is stable and working. Much appreciated and cannot say thank you in a better way for the assistance.