Loading a combo box

[rabatwork]

I have multiple types of names which are related to list(s) of titles. Is there any way to select the name type (category) in a combo box and have the appropriate titles be loaded into another combo box for selection?

 

[simongallop]

In the second box for the row source select the fields that you want to see plus the field CATEGORY. In criteria for category use the code = [Forms]![frmName]![cmbName]

You then need to go to the first combo box and in the event tab of the properties you need to create code in On Change being Me.cmbName2.Requery

HTH

Simon