How do I populate data from one form to another?

[Guest]

I have created a data base to house training data for our employees. This is
a new data base so it currently is very small but I anticipate it to grow
considerably. At this moment I have a total of 3 tables: Student
Information; Maintenance Training Records; and On the Job Training Records.
I have created relationships between these tables using the student
certification number. What I am attempting to do is create a form for each
of the training records. When I enter the student certificate number I want
the student information to populate into the training form. I also want to
be able to open any of the training forms and if a new student is entered, I
want the student form to update with the new student.

I believe that I will need to use subforms to do this but I am not sure.
Other than the certificate number, none of the student information is housed
in my other tables. Any help that you may provide would be wonderful.

 

[Guest]

Ericka, try creating a query with all your tables. You can use a separate
query for each form if you want, or put all the fields into one query. Use
the query(s) as your control source for the forms you want to auto-populate.