How do I set up a field to autonumber the ID numbers

[Guest]

I have a form that contains the same information as my table does. I want my
form to autmatically assign each record an autonumber which corresponds to
the table. For example : each new record in my form would be their own
number.
Contact ID Number is my primary key and I want it to autmatically assign
each new entry it's own number and then transfer that information to the
table. I can't seem to get my form to do this. HELP PLease.

 

[Rick B]

Is that field set as an autonumber on your table? If so, you are done.
Just include that field in your form. When you add a new record it will be
updated.


Just FYI, autonumber fields are designed to create a unique key. In most
cases, you should not use this number for anything. When records are
deleted (for example) you will end up with gaps. If you want a menaingful
number, there are other methods to look at the highest number in the field
and add one to it.


Rick B

 

[Guest]

Yes, my field in the table is set to autonumber. What I am making is a
database for all our contact people in many differerent fields of
employement. I made my form a tabular form and on the front page I have
contact ID number, first name and last name as fields. I want to bring this
page up to enter the information on each new contact and then have it update
to the contact table. But for some reason I can't get it to do it. I am
stumped. Any help is greatly appreciated.

 

[Rick B]

What is the Record Source of your form? Is it bound to the table or to a
query based on that table? If so, you would be able to do what you are
stating.


Rick B

 

[Guest]

I put the table's primary key as where the form referenced the information
but that didn't work. I am very new to this. I am pretty good with computers
and can almost figure out most programs on my own. For the most part I am
doing ok, it is just the codes in this program are confusing to me. And why
this control source won't work on this one is beyond me. And, while I am at
this, I want one field to be based on what the other field is put in, how can
I do that. Microsoft for dummies show you how to do the technical stuff very
well. Thanks for you help.

 

[Guest]

I finally got it. I deleted the one form that I was working on and started
over. Now it's working. Thank you for your help.