I have a form that contains alphanumeric IDs, I want to create a filter for all IDs according to year. The filter will apply afterupdate on a combo box.
The combo box is populated by two digit numbers representing years (05, 06, 07, etc).
The ID pattern is letter-year-dash-sequence (A08-0001). I intend to use a filter that follows something like "*08-*" (the dash is important so that it does not count similar numbers in the sequence part).
The code below doesn't work (yes, I'm that kind of a newbie to try deformed sql statements in VBA):
Private Sub YearListTag_AfterUpdate()
If IsNull(Me.YearListTag) Then
Me.FilterOn = False
Me.Filter = "SID = like "*Me.YearListTag-*"
Me.FilterOn = True