link 2 or 3 forms

[Mariapaiva]

I need to link automatically 2 or 3 forms. I was thinking that
on the last entry field (form 1) I should add an instruction to automatically open the new form and
the cursos should appear on the first data entry of this new form (form2).

How can I do so?
thanks

[ItsMe]

Perhaps you can JOIN some fields in tables using query objects rather than form objects. What is the task the User is performing with these forms, edit data, append records, view records?

[A S MANN]

At the last entry field (form 1) Create a macro to open form command to open new form(2) and use Go to Command go to first data entry of this new form (form2).

[Mariapaiva]

Thanks and it work very well ASMann.

May I post to you another question and kindly request you to help me on this. How can I append the same data in both tables? Let me explain better.... in table 1 I do have 2 IDs (the automatic and the questionnaire ID). the questionnaire ID I need to repeat it in all tables when the data entry entries the number. Is it possible? It is not just a link (relationship) but input in one form and goes to the 4 tables????

Thanks

[A S MANN]

Create a append Query from DATA which need to be append in another table. Click at append in Query design and select the table where data need to be appended.
Repeat the same and select second table where data need to be appended.
take care of questionnaire ID in query design
Create a macro at form at after update property of a field
in that macro OpenQuery command add the above created query 1 and query2
that will auto append data when data changes in form
You can append data to as many table as you want.
am i clear.