If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Adding new records
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!. |
#2
|
|||
|
|||
Adding new records
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! "James Chevers" wrote: 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!. |
Thread Tools | |
Display Modes | |
|
|