Full Version: Cascade
UtterAccess Forums > Microsoft® Access > Access Forms
Hi Everyone

I cannot for the life of me get Cascading Combobox's to work in the attached Db.

When I select a Level it should only show Courses associated with that Level in the Course Combobox.

Any help appreciated

Click to view attachment
The problem appears to be that you are dealing with a Main Form, Sub-Form, and Sub-Sub-Form. Given this Scenario, the Syntax in the AfterUpdate() Event of cboLevel would be similar to:
Private Sub cboLevel_AfterUpdate()
Dim strSQL As String

strSQL = "<Your SQL Statement & WHERE qryCourseNames.LevelID = " & Me![cboLevel] & ">"

Forms("frmStudents")![frmStudentsYearsSubform].Form![frmYearCourseSession1subform].Form![cboCourse].RowSource = strSQL
End Sub
Hi ADezii

Many thanks That fixed it

This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.