Access Database

[Guest]

I just created a database that contains information on a student as well as a
periodic evaluation that they fill out. The student has a total of 8
evaluations in the form. I created a query that connected both the table of
evaluation answers and the student's information - however when i created a
combo box that allows the user to skip to another student the student's name
repeats itself 8 times because of each evaluation form. Is there any way
possible to change this?

 

[John W. Vinson]

I just created a database that contains information on a student as well as a
periodic evaluation that they fill out. The student has a total of 8
evaluations in the form. I created a query that connected both the table of
evaluation answers and the student's information - however when i created a
combo box that allows the user to skip to another student the student's name
repeats itself 8 times because of each evaluation form. Is there any way
possible to change this?

Yes; but since you didn't post any useful information about your table
structures or how the form is constructed, it's a bit hard to say how!

What's the Recordsource of your form? How are you storing the eight
evaluations? In eight records in a one-to-many related table, displayed in a
Subform (good)? Eight fields (bad)? Eight separate simlar tables (even worse)?

What's the RowSource of the combo box? Post the SQL.

John W. Vinson [MVP]