Thread: Combobox selecting All
12-16-03, 10:17 #1Registered User
- Join Date
- Dec 2003
Unanswered: Combobox selecting All
I have a combo box where I would like to select either by Month year or All.
When I open the form and select from the combobox say 092003 the data shows correctly then I select all and the data shows all. but when I go back and select another month/year it still shows me all.
How would I correct this.
Row Source Type = Table/Query
Row Source = SELECT [Earned Doctorates Institutions Workload Query].Workload FROM [Earned Doctorates Institutions Workload Query] UNION SELECT "(ALL)" FROM [Earned Doctorates Institutions Workload Query] ORDER BY [Earned Doctorates Institutions Workload Query].Workload;
Dim Fltr1 As String
Private Sub cboworkload_AfterUpdate()
If cboworkload = "(all)" Then
Fltr1 = ""
Fltr1 = "[Workload] like '" & cboworkload & "' "
Me.Filter = Fltr1
Private Sub Form_Open(Cancel As Integer)
Me.Filter = ""
Me.FilterOn = True
12-17-03, 13:13 #2Registered User
- Join Date
- Sep 2003
Have you tried Me.FilterOn = False when the user selects (ALL)?
Have you also tried using the me keyword before cboworkload?All code ADO/ADOX unless otherwise specified.