Adding new records

[James Chevers]

I am new to access but i'm pretty sure i've done a good job....untill now. I
have created a database that strictly stores information and does not need to
do any calculations. my database is 7 forms and 7 tables kind of like a
survey. the problem i am facing is that i am supposed to be improving an
existing database that contains 396 records. My database shows all these
records across all my forms properly and effectively. The problem is when i
wish to add a new record. My main form with an autonumber will add the new
record and give it an ID. but when i click on one of the buttons linking my
main form to my other forms the record information will not carry over, in
fact if i put in the data manually it shows up in the table but not on the
displayed form. Is there anything i could do, could someone please help me!.

 

[Chefjay22]

James,

I ran into this same problem recently. I am going to make a few
assumptions... I take it the secondary form is built from a query looking at
the AutoNumber from the main form. From what I gathered, the record is not
complete until closed or moving on to the next record, so therfore you cannot
query the AutoNumber to see the next related data etc. So I'm not a
programmer, so this is what I did:

Created a Macro that did the follow:

GotoNext Record
GoToPrevious Record
Open Form (The Form you are wanting to go to)

For me, this made the record final and my problem was solved. I set my
command button to use the new macro... problem solved, no code written lol.
Hope this helps!