Form Filter with like (1 Viewer)

andy1968

Registered User.
Local time
Today, 13:43
Joined
May 9, 2018
Messages
131
I'm trying to filter a subform based on a value on the main form.


I'm filtering on 2 fields.


One is Job.


The for the second field, I want all the records that have the same characters prior to the 1st "R" in the string.


Here is the code.



Code:
If InStr(Me.ContractorNumber, "R") > 0 Then
   Dim CN as String

   CN = Left(Me.ContractorNumber, InStr(Me.ContractorNumber, "R") - 1)
   
    Me.frmSubmittalEntryResubmittalList.Form.filter = "[Job] ='" & Me.Job & "' And  [ContractorNumber] Like '*' '" & CN & "'"
    Me.frmSubmittalEntryResubmittalList.Visible = True
    Me.frmSubmittalEntryResubmittalList.Form.FilterOn = True
End If
I get a run time error '3075': Syntax error (missing operator) in query expression '[Job] ='C18231F' And [ContractorNumber Like '*' 12"
 

theDBguy

I’m here to help
Staff member
Local time
Today, 13:43
Joined
Oct 29, 2018
Messages
21,358
Hi. Maybe you meant something like:
Code:
...And  [ContractorNumber] Like '" & CN & "*'"
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 04:43
Joined
May 7, 2009
Messages
19,169
...
...
... And [ContractorNumber] Like '*" & CN & "*'"
 

theDBguy

I’m here to help
Staff member
Local time
Today, 13:43
Joined
Oct 29, 2018
Messages
21,358
Hi. Glad to hear you got it sorted out. Good luck with your project.
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 04:43
Joined
May 7, 2009
Messages
19,169
you're welcome, sir!
 

Users who are viewing this thread

Top Bottom