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.