Jamo,

I concur with Tom that your design of the tables is incorrect. Please
explain what the fields beside student name and StudentID are in the Rubic
table so I can suggest a better design of your tables. Are the Rubic rable
fields dated so you enter them throughout the school year?

Steve



"Jamo" wrote in message
news

--
Center for technica education

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.