Please show me how to make the form generate the ECO number automatically

[cadmaster]

Hi Everyone,
Can someone please show me how to make the form generate the ECO numbber automatically? Please see attached file for detail.

I really appreciate for you help!


Thank yoo

[June7]

Could just let an autonumber field generate unique value and prefix with ECO by formatting but that has its problems. No guarantee the number will be sequential.

Creating custom unique identifier requires VBA code. Common topic.

Review: http://forums.aspfree.com/microsoft-...ta-403208.html

[cadmaster]

Hi June7,
I am a MS access beginner. I don't know much about VBA code.
Could you please show me how?
thanks
Phe

[June7]

I have given an example with the referenced thread. Adapt code for your situation. This is a fairly common topic and there are many examples.

The trickiest part of code is figuring out what event to put code in. I don't know enough about your data structure and business processes to be specific.

The more automation and 'user friendly', the more code will be required. I suggest that if you don't already know them, you get familiar with basic programming concepts and then learn VBA language.