need help with forms

[wendy184]

Hi, i really hope someone can help with this its been driving me crazy for days. OK, I want to do a walk through questionnaire on access, i've set up all the tables for the different topics and designed the forms. The problem that I have is when I test it - I type the info needed into the first form, click the command button to go to the next form (which is a different table) but my ID and name doesn't pull through to the next form, I get a new record instead. What I want to do is just make one record per completed questionnaire. As it stands at the moment people will have to re-enter or lookup their ID and name every time they move onto a new form. Am I making any sense?!

 

[CoachPhil]

You will probably need to compile all info on one table or 'link' the tables

 

[wendy184]

Thanks for your reply coachphil, I've decided to use just the one table to get around it although i think i might still have the same problem with just one table, i have the feeling that if i make more than one form from the table data, when i click 'next' to open the next form i will get a new record again!