Default Value in Access Table

D

DigDoc Steve

I'm attempting to create a database with a table that has an autonumber
field, and a column that has a numerical value. I want the default value to
be the same as the autonumber field, so that there's a number assigned, or
the user can change the number, if they have to. Anyone know how to
accomplish this?


I choose Polesoft Lockspam to fight spam, and you?
http://www.polesoft.com/refer.html
 
A

Allen Browne

You cannot use the Default Value in the table for this, because the new
AutoNumber is not yet available at the time Access assigns the Default
Value.

Instead, you can use the BeforeInsert event of your form to assign the
value.
 
Top