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.