Added Primary Key not showing up....

R

rstiles

Good Morning all,

I am finishing up a 2003 application and I have come across a small
problem...

I decided to add an autonumber primary key to one of my tables and for
some reason it does not want to show up anyhwhere exept the table that
I created it in, I am trying to add this to one of my forms and thus
far I have tried adding a text box and adding it as the control source
and through the field list.

I know that I should have added it at the beginning and this is most
likely the reason why; is there a way to get this show show up without
redoing the whole table?

Thanks for your help,

Ron
 
A

Al Campagna

When you added the AutoNum to your table, did it populate?
Is the RecordSource for your form a query?
Did you add the new field to that query?
Was the new field listed in your Field List in the form design?
--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."
 
R

rstiles

Al,

Thankyou...I am beating my head against the wall know for not thinking
of this simple solution which I knew.

Apparently after working 13 hours strait on this application my brain
had placed itself somehwhere else, if someone finds it, would you
please let me know.

Ron
 
Top