Problems with drop down list

[Gelpaks]

I don't know if the solution is too simple for me to see clearly or what! I
have a database that keeps track of students attending summer school. There
is a student form that shows various information pulled from several tables
using tabbed browsing.
My problem is I have an add record form that has two drop down boxes
populated by queries that pull from the teacher table. These same queries
are used in the student table to show which teacher the student has for which
course and also in the main form. Usually when the drop down menu comes open
(showing teacher last and first name) and a selection is made, it shows the
teacher's last name as the selection. This works as it should in the student
table and the main form. On the add student form, however, things work a
little differently. Although when the selection is made the box shows the
last name, when the form is closed and the student info looked at on the main
form, the name now shows the teacher's first name instead of the last. If I
alter the query to show first name then last, the main form will show the
last name, but the add student form shows the first name. Can anyone help me
figure out why it is this is happening??

 

[Gelpaks]

That was it! I can't tell you how many times I went over these forms and
queries adjusting and readjusting them. Thank you so much!