Greetings.
I have a question regarding MS Access Me.Filter. In short, I am building a personal database for my CD and DVD collection and I have a few CD's that start will a number instead of a letter - such as the band, 3 Doors Down.
On my form, I have already completed the VBA scripting for the letters A through Z by using the following:
Private Sub ArtistBFilter_Click()
'Only show Artist that begin with B
DoCmd.Requery
Me.Filter = "CD.Artist Like '" & "B" & "*'"
Me.FilterOn = True
Artist.SetFocus
End Sub
Can someone please tell me how to create a sub-procedure that would filter out all the Artist's that do not start with a number (0-9) under the same event, e.g. I would like to see all the Artists that begin with 0,1,2,3...9?