Update from a Combo Box

[Greg]

I have a combobox that a teacher would use to select a student who did a bad
thing.

I want the student's ID to load in automatically when the teacher selects
the student's name. The student's information is stored in a table called
tblStudentData and the combobox is called Combo 10.

Should I just use a little subform to do this, or is there an easier way?

Greg
The Oft Access Confused

 

[Sandra Daigle]

Hi Greg,

It seems to me that the "bad thing" should be stored in another table -
which is linked to the studentID. For example:

tblStudentDemerits
---------------------------
Studentid
DemeritDate
DemeritCause
NumDemerits
TeacherID
etc..

Then in your form, you might have an unbound combo which is used to navigate
to the student record, then in a subform of the student form, you enter the
demerit(s).

Note that on the mainform, you probably also should have a textbox for
studentid, which is not used for navigation but that is used to display the
id of the current student record.