Cascading form record source

[cheuschober]

Heya. I hate posting yet another cascading query but I just poured through the first 40 bits and couldn't find something similar.

Basically, I seem to have an errored idea in how to effectively used cascading boxes on a larger form-wide scale.

Basically I have a form with an unbound combobox in the form header: cboSchool

The detail section should only have two fields, StudentID (txtStudentID) and a boolean (bolOT) both of which exist in a specific table source (tblStudents). StudentID is a locked field.

What I would like to do is only have the StudentID's available that are valid for the school. I attempted using a query in the record source that would reference cboSchool but I keep ending up with blank forms. (There's a string of queries that link the schools found in cboSchools to StudentID)

Any ideas?
~Chad

 

[cheuschober]

Yup. I put Me.Requery into the AfterUpdate event on the form.

Edit: Re 'on the form' I should say, in the AfterUpdate event of cboSchool

 

[cheuschober]

Ahh, now I feel a bit of a fool. Spelling it was. Thanks just the same Pat. This was a re-design of an older form and there was a teeny-tiny little box with the same name.

Thanks. Regards,
~Chad