Creating Autonumber Field

[James]

How can I create an autonumber field using VBA, and set it to the primary key
field?

eg) newtable.createfield("KeyCode", dbAutonumber) --- something like this???

please help?

 

[James]

Never Mind, i figured it out.