Filter String

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 & """"
 
Never mind, I figured it out:

For those who are interested, it was:

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run select query from VBA code where criteria comes from a multi select ListBox 2
Cleanup Code on Form ?? 3
report filter code 6
Filter by date range for any one of three dates. 0
Including blank fields in results when filtering a report 1
Message Box to Display a count of Records 3
No Data on Form Open 3
variable coding help 1

Back
Top