Filter syntax

K

Kirk P.

I'm building a filter based on criteria from a form. I can't get the syntax
right.

Here's what I've got.

strWhere = "[HR_SUPERVISOR2] Like " & """ & Me.cboSupv2 & " * ""

I'm trying to get HR_SUPERVISOR2 Like "Anders, Donald*" - with Anders,
Donald supplied by cboSupv2. Help!
 
M

Marshall Barton

Kirk said:
I'm building a filter based on criteria from a form. I can't get the syntax
right.

Here's what I've got.

strWhere = "[HR_SUPERVISOR2] Like " & """ & Me.cboSupv2 & " * ""

I'm trying to get HR_SUPERVISOR2 Like "Anders, Donald*" - with Anders,
Donald supplied by cboSupv2. Help!
Click to expand...


Tyr this:

strWhere = "[HR_SUPERVISOR2] Like """ & Me.cboSupv2 & "*"""
 
K

Kirk P.

That did it. Thanks!

Marshall Barton said:
Kirk said:
I'm building a filter based on criteria from a form. I can't get the syntax
right.

Here's what I've got.

strWhere = "[HR_SUPERVISOR2] Like " & """ & Me.cboSupv2 & " * ""

I'm trying to get HR_SUPERVISOR2 Like "Anders, Donald*" - with Anders,
Donald supplied by cboSupv2. Help!
Click to expand...


Tyr this:

strWhere = "[HR_SUPERVISOR2] Like """ & Me.cboSupv2 & "*"""
Click to expand...
 

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

Type Mismatch in Report Filter 3
Report based on form filter? 1
Filter Report by Form 2
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Start a mail merge upon opening the document 1
How to paste this down? 3
strWhere criteria 2
Outlook 2007 connect problem in Windows 7 0

Top