chrisjames25
Registered User.
- Local time
- Today, 05:09
- Joined
- Dec 1, 2014
- Messages
- 401
Hi
I have a continuous form with made to look like datasheet. It has 3 columns. Category Genus Variety.
The following code brings up a filter menu for each "column" when i double click on it.
That works great but what i really want is the form to remember my selection. For example using drinks as an example. If i chose alcoholic from the category menu the filter would be applied but if i then double click on the next column i would still be able to choose sub drink categories that are not alcoholic. What i want is like in excel when u filter one column the following columns also filter down to only show what is available within the already filtered column - just like you do with cascading comboboxes.
Any ideas? finding nothing on the web.
I have a continuous form with made to look like datasheet. It has 3 columns. Category Genus Variety.
The following code brings up a filter menu for each "column" when i double click on it.
Code:
Private Sub Lbl_Column1_DblClick(Cancel As Integer)
Dim Items As Integer
Items = Me.RecordsetClone.RecordCount
If Items = 0 Then
Me.FilterOn = False
Else
DoCmd.GoToControl "Txt_Column1"
DoCmd.GoToRecord , "", acFirst
DoCmd.RunCommand acCmdFilterMenu
End If
End Sub
That works great but what i really want is the form to remember my selection. For example using drinks as an example. If i chose alcoholic from the category menu the filter would be applied but if i then double click on the next column i would still be able to choose sub drink categories that are not alcoholic. What i want is like in excel when u filter one column the following columns also filter down to only show what is available within the already filtered column - just like you do with cascading comboboxes.
Any ideas? finding nothing on the web.