Filter syntax

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

Guest

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!
 
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 & "*"""
 
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...
 
Back
Top