Filter String

D

Debra Ann

Below is a string of code that I am using to pull a specific chapter number.
Now the user wants me to pull all subchapter numbers with it. This means I
need the LIKE with the wildcard. I have no problem doing it in a query but
all the quotes are confusing me and I can't get it to work. Could someone
please tell me how the string would go for [ChapterNo] = Like "Chapter*".

Thanks,


Dim strWhere As String
strWhere = "[ChapterNo]=""" & Me.Chapter & """"
 
D

Debra Ann

Never mind, I figured it out:

For those who are interested, it was:

strWhere = "[ChapterNo]Like """ & Me.Chapter & "*"""
 
Top