Adding new records

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

Guest

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!
 
James said:
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!

I don't really understand what you want.

Let's start with the table(s). Forms don't have data (well most of the
time) they are windows to the tables...

Could it be that the forms are referring to the same table? I suspect
that the form needs to "refresh" to go back to the table and take a look at
any new data there. Try issuing a refresh command on an event that will
take place when you need the new data displayed.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top