Member Avatar for SMIFMD
SMIFMD 0 Newbie Poster

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?

Edited by kvprajapati because: Added [code] tags.
  • 1 Contributor
  • 0 Replies
  • 79 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.