Auto incerment of numbers depending on prefix (1 Viewer)

[swaroop1012]

Hi all,

I have a really serious problem with auto increment of numbers.

To say something about what i am trying to do, I have a autoform which i made from the table data. this auto form have a field "wardname". This is base ona lookup table which has 10 different wards with codes.
Ex: stafford - ST, West - WE, East - EA, North - NO etc.

I have another field set up to collect the codes.

Now my problem is, as the user enters the wardname data in the form, it should start numbering and the numbering should auto increment based on the prefix.

I.e. data1: Stafford - ST: ST-1
Data2: Stafford - ST: ST-2
Data 3: East - EA: EA-1
Data 4: West- WE: WE-1
Data 5: East - EA: EA-2
Data 6: Stafford -ST: ST-3

It should incerment this way depending on the ward code. Any ideas pls.

Thanks in Advance.

 

[MStef]

Look at "DemoAutoIncrementA2000.mdb" (attachment, zip).
Open Form1 and try.

 

[swaroop1012]

Thanks Mstef....thats really helpful db.