I have two combo boxes in my form. One linked to a table of subjects, the other linked to a table of subsets of each subject. The two tables have a one to many relationship (subjects to subsets)and are linked by the subject ID number. Once a subject has been selected from the first combo box on the form, I only want the subsets relevant to the selected subject to show in the second combo box. How can I do this?

on the afterupdate of the first field, change the rowsource of the second field like this.

Me.[SecondField].Rowsource="Select * from [table] where ID=" & me.[FirstField]

me.[secondfield].requery