Tom:
Thank you for the replay ,however the reason that I have both the Student
Id and the student name in the form is that the teacher entering the data
does not know the student id but does know the students name.The reason the
the student Id is there also in case two student have the same name. Can I do
it??
--
Center for technica education


"Tom van Stiphout" wrote:

On Mon, 17 May 2010 15:18:01 -0700, Jamo
wrote:

You have an incorrect database design. The StudentName field should
only be in the Students table.
Then creating a dropdown which now only has to populate
tblRubic.StudentID is simple.

-Tom.
Microsoft Access MVP



I have Two Tables ,a Student Name Table with Two Fields, Student Id
and
Student Name the other table is a Rubic Table and has the same two
fields
along with other fields. I have created a form with a combo box(Names)
on the
form and I am trying to get the Name and the Student Id to be entered
into
the into the Rubic Table fields but I can't seem to get the Student Id
to be
entered. I know I am doing something stupid but I can't seem to make
it work.
Thank you in advance for all the help. You guys are great.
.