This [Evenet Procedure] is now in the code on the After Update for Combo Box F which is in the f_filter-nycklar subform.
Private Sub F_AfterUpdate()
Dim strFilter As String
strFilter = "[Serie nr] BETWEEN " & Me.F & " AND " & Me.T
Me.f_filter_nycklar.Form.FilterOn = False...
Cheers for the reply. I tried that. The combo box still will not sort out the values.
Whatever I enter in the two combo boxes the list rows remain intact and the same. All of them listed.
Access 2007
Inside main form f_order
I have a subform f_filter_nycklar
with only one column [Serie nr].
A list of unique serial numbers.
10001B
10002B
10003B
... to
99999B
The subform is based on q_filter_nycklar which in turn is based on tbl_filter_nycklar
I have two unbound combo boxes both...