Update from a Combo Box

  • Thread starter Thread starter Greg
  • Start date Start date
G

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
 
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.
 
Back
Top