Hello I was wondering if there i

[JSD]

Hello

I was wondering if there is a way to set a default in a number field to make the number act as an auto number on new records?

Any help would be interesting and helpful.

THanks

Jeremy

 

[cuok]

Hi!

not sure but try using Static Number
see help how to use it/

good luck

CUOK

 

[Darrylles]

Hi,

Personally, I'd use a seperate table that stores the last used number.

When a new record is stored - use vba to increment last number, store it in seperate table and insert it into your record field.

Why not use autonumber - it does exactly the same?

Regards,

Darrylle "Never argue with an idiot, he'll bring you down to his level - then beat you with experience." darrylles@totalise.co.uk

 

[JSD]

Hello

THanks for the point in the right direcxtion. What kind of expression could be used to increment the last number used?

THanks for your time

Jeremy