Another question

(I originally posted this question yesterday, but somehow it wound up
attached to an old thread from 2000 that I did not even read. How did
that happen? At any rate, my question is...)

Our database has two tables... one is a Directory table with the
contact information for each student we work with. The student ID #
is primary key. The 2nd table, linked on primary key, also includes
the student's name, so our data entry people won't get confused
entering records in for each student. (Form 1 is directory info; has
a button taking the user to the records subform to input the specific
records information for that student) Is there any way to set up the
form so that the ID# and name can automatically be populated into the
same fields on the 2nd table/screen?

Thanks!

Lisa

Normally, if you are talking about a subform embedded in the main form and
you have master and child relationship established, the fields should
populate on their own. If your form is not linked but is actually another
form that opens up, you can use default values to point to the Student id on
the first form. Use your expression builder on the default line for your
syntax. It would look like
=Forms![frmFirstForm]![StudentID]

"Lisa" wrote:

(I originally posted this question yesterday, but somehow it wound up
attached to an old thread from 2000 that I did not even read. How did
that happen? At any rate, my question is...)

Our database has two tables... one is a Directory table with the
contact information for each student we work with. The student ID #
is primary key. The 2nd table, linked on primary key, also includes
the student's name, so our data entry people won't get confused
entering records in for each student. (Form 1 is directory info; has
a button taking the user to the records subform to input the specific
records information for that student) Is there any way to set up the
form so that the ID# and name can automatically be populated into the
same fields on the 2nd table/screen?

Thanks!

Lisa