So I had three cascading combo boxes working fine, however I was unsure how to then get text boxes on the form - which relied on the last combo box - to gather data without creating a subform. having given up on that, I did create the subform, however somewhere along the way I broke my cascading combo boxes... your assistance on this is much appreciated.
The form in question is the "AddAssessmentRecord". When I enter a district into the first field, the following error message appears:
When I debug, the following section appears to be the problem:
I haven't changed any of this code since I made the alteration (there was some more code below it, which referenced the fields now in the subform, but I don't believe this should have affected it.
When removing the now unnecessary fields from the query, I did accidentally remove the District, Team and Assessor fields, but these have also now been added.
The reason I have also mentioned the subform in the title/tags, is I am unsure how to then get the subform to use the Assessor's name field as part of its query, you assistance with this will also be much appreciated.
I have attached my database to assist in your assistance.