Hi There,

I have a table that has two numbers, both require incrementing with each record.

These take the form of "00"0"/05" and "Book11 Enc"0.

I want these to update automatically but Access won't let me use two autonumbers in same form. Does anyone have a suggestion to get round it ?

Thanks.
Alex.

Alex, It is generally not recommended that you use the auto number where you need a method to sequentially number data elements. There are several reasons but I'll spare you the speech. A better solution (In my opinion), would be to write a short function that would return the sequential part, maybe using a dmax()+1 method.

:) Ken

The autonumber is used to provide a unique identifier for a table row. Nothing less, nothing more.

I'm quite new to all this and don't really understand the way to do this.

Can anyone give me/point me in the direction of some sample code ?

Alex.