Tracking buttons clicked on a form

[Ricoy-Chicago]

Using Access XP.
I have a "Menu" form containing 4 to 8 teachers names (depending on the
number of subjects taken by a student). The student clicks on a command
button associated with a teacher's name so the student can fill-in an
evaluation survey. In the "Menu" form a have a checkbox should be checked
automatically if the student fills a survey for the teacher. For example:
Student clicks on the command button [Teacher One] in the [Menu] screen
The Survey form for "Teacher One" shows
Student fills survey
Student returns to [Menu] screen (No problem up to this point!)
The check box for [Teacher One] has to be checked because the student did
(or at least accessed) the teacher's survey.
If a set the checkbox [chkDidSurvey] = yes, ALL the checkboxes turn to yes.
The [Menu] form has been set to "Continous forms"
Any help or hints?
thank you.

 

[Evi]

It sounds like your Checkbox needs to be a Yes/No field in your
StudentSurvey table (You do have a StudentSurvey table don't you? - One
which has foreign key fields that link to the Student Table, the Teacher
Table and possibly the Survey Table, depending on how many surveys you need
to record.)

Evi