Full Version: Cascade
UtterAccess Forums > Microsoft® Access > Access Forms
mike60smart
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
ADezii
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:
CODE
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
mike60smart
Hi ADezii

Many thanks That fixed it

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