On Fri, 21 May 2010 14:35:01 -0700, Jamo
wrote:

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??

The student *name* should only be in the student table.

That doesn't mean it can't be on the form! The form is just a window, a tool;
it's not the table.

Normally one would have a Student table with a unique StudentID, LastName,
FirstName, *and other identifying information*. On the Form you would have one
or more combo boxes, bound to the StudentID, displaying the name and (when
dropped down) other identifying information - grade or class name, home
address, StudentID, whatever is useful in your circumstances.

in your example... if the teacher doesn't know the ID, what help is it to have
two records in the form both showing Mike Smith?
--

John W. Vinson [MVP]