hi guys,

for my project i created a database in Access 2000.
In one of my tables my primary key is an autonumber.

my table fields are:

StatusNumber -> Autonumber
StatusName -> Text

in my project i wrote a statement that insert a new StatusName but i get an error becouze it needs me to send also a new StatusNumber.

why does the AutoNumber field need me to give him a number? how can i avoid that?

thanks,
ohad.