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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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
 
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.
 
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
 
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.
 
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.
 
Back
Top