Making lookup table dependent on other field values

[gibby]

Hey there,

I was just wondering if there was a way to make the items in a lookup table dynamic; specifically, dependent on the values entered in another field.

The situation I want to do this in is as follows: I have a student record database for an elementary school teacher, and she wants to keep track of parent conversations. So I have a conversation table that stores the student in one field and the parent spoken to in another field. I'd like the make the parent field a drop-down list that the user can choose either the mother or the father from. But of course, this depends on which student was entered into the student field first. So how do I make the contents of the parent drop-down list dependent on the student entered in the student field?

Gibran

 

[dette]

in the row source property of parent, try this:

SELECT tblname.[parent ID], tblname.[parent] FROM tblname WHERE ((tblname.studentname) = Forms!formname!studentname));

i'm just new to access but have the same validation in the database i'm working on right now...hope this helps you...if not, i'm sorry...

 

[Pat Hartman]

You need one more step. In the AfterUpdate event of combo1, you need to requery combo2.

Me.cboParent.Requery