SubForm with query conditional combo boxes

[ThebigCt]

Student Form-Field Experience Subform




On the [Student] Form, I need a subform with the form[Field Experience] in it. I have placed the form in the student form but my issue is getting the query to work with selecting semester, year, and then the field experience populating that combo box. I have created these type of cascading combo boxes before, but for some reason I cannot get them to work in a subform.

I have attached the database below.

[June7]

The subform is in datasheet view and the comboboxes are multi-column using lookup? Yes, this can be an issue in datasheet. Have the combobox requery when it gets focus. Some records will appear to not have data because the lookup value is not in the RowSource for the current record and the RowSource property applies to all instances of the combobox (it is, after all, just one control).