autonumber

  • Thread starter Thread starter andym
  • Start date Start date
A

andym

I have a prime number (autonum)
in table format "IF-04-"000 so it reads as IF-04-001 next
record IF-04-002 and so on. Once it becomes 2005 I need
to change to IF-05-001 and continue like i did from the
beginning. So 05 will change and 001 will start again.
 
Andy,

I'm afraid you acnnot do that with an autonumber... Your
format only affects the way you see the number, to Access
the number is actually 1,2,3... so IF-04-001 and IF-05-001
are both plain 1, which there's no way you can make Access
accept in an autonumber field, or any other PK field for
that matter. To do what you want you need to change your
PK to a text field and assign values some other way (e.g.
use default value or a macro or code to assign new PK
value in a record enrty form).

HTH,
Nikos
 
Back
Top