baldeagle
Registered User.
- Local time
- Today, 05:28
- Joined
- Nov 9, 2004
- Messages
- 38
I think I've solved a method to have cascading comboboxes on a continous subfrom.
The after update on the first box sets the query the drives the secondbox's rowsource, and blanks out all the boxes below it. And so on.
All of the comboboxes are fed by one table.
Comments?
The after update on the first box sets the query the drives the secondbox's rowsource, and blanks out all the boxes below it. And so on.
Code:
Dim EventTP As String
EventTP = Me.cbxClass1
Me.cbxClass2.RowSource = "SELECT distinct Class2 FROM tblEventTypes WHERE (((class1)='" & EventTP & "'));"
Me.cbxClass2 = ""
Me.cbxClass3 = ""
Me.cbxClass4 = ""All of the comboboxes are fed by one table.
Comments?
