Auto numbering - some code please

[MalcR]

I’m a bit of a drag and drop merchant, but this one can’t be solved using the wizards. Would someone be kind enough to point me to some code which will allow me to resolve the following:-

My table has three fields Phase, Section and DrawingNo. I’m wishing to record new numbers in the DrawingNo field, when a new Section is added within an existing Phase then assign the next available sequential number or reset to 1 if a new Phase value is added.

Thanks

Using Access 2000

[PEB]

Hi,

U need this in form or in table or a query?

In table in Access It seems a bit impossible coz there isn't the kind of triggers that maybe u are looking for...

:)

[MalcR]

Hi,

U need this in form or in table or a query?

In table in Access It seems a bit impossible coz there isn't the kind of triggers that maybe u are looking for...

:)

Hi,

The input will be via a form

[PEB]

Ok,

So..


In your form...
Go to your control named Phase

After update event procedure for phase:
Me!DrawingNo=1

After update event procedure for Section:
Me!DrawingNo=nz(Dcount("DrawingNo","YourTable","Se ction='"+Me{Section}+"'"))+1



Best regards