I am a new user of Access, and i was hired to create a database using
existing information and to add new information. I have finished my database
and it is very simplistic, there are no calculations only forms and tables. i
have 398 records from past information already in my database. My main page i
can add a new record and it gives me an ID through autonumber. on my main
page i have around 6 buttons all linking to different forms. The buttons are
configured to open up a specific record everytime so it's like your reading a
survey with 7 pages. However when i add this new record on my main page it
will not add a new record on my other forms. If i try to manually put in the
information it somtimes stores it on the table but it will erase it from
display in the form. I hope i have explained myself clearly can someone
please please help me!