Textbox Filter Contain in Datasheet

[margzj]

Hi, I want to filter my Company Name with contain but my company name value is integer.



I have this code for my other filter, this one is working. I am having trouble with my Company Name.

If Not IsNull(Me.ContactPerson) Then
    Forms("frmMain").Filter = "[ContactPerson] Like " & Chr(34) & "*" & Me.ContactPerson & "*" & Chr(34)
    Forms("frmMain").FilterOn = True
End If

[ranman256]

why would your 'name' be a number? why isnt it company#?
but for numerics, dont use quotes:

If Not IsNull(Me.ContactPerson) Then
    me.Filter = "[CoNameID]=" &   Me.ID
    me.FilterOn = True
End If

[margzj]

why would your 'name' be a number? why isnt it company#?
but for numerics, dont use quotes:

If Not IsNull(Me.ContactPerson) Then
    me.Filter = "[CoNameID]=" &   Me.ID
    me.FilterOn = True
End If

If I search with this code, It will search exactly equal​ not contain.

[June7]

Show us the code that is not working.

Do you mean the CompanyInfo_ID field is integer and of course using a LIKE operator and wildcard in filter criteria on this field will not work.

If you are filtering a form and want to use the CompanyName as criteria, then you need to include the CompanyInfo table in the form RecordSource.

[margzj]

Show us the code that is not working.

Do you mean the CompanyInfo_ID field is integer and of course using a LIKE operator and wildcard in filter criteria on this field will not work.

If you are filtering a form and want to use the CompanyName as criteria, then you need to include the CompanyInfo table in the form RecordSource.

Yup that is my problem

[ranman256]

you dont contain ID. they are exact.

[margzj]

Show us the code that is not working.

Do you mean the CompanyInfo_ID field is integer and of course using a LIKE operator and wildcard in filter criteria on this field will not work.

If you are filtering a form and want to use the CompanyName as criteria, then you need to include the CompanyInfo table in the form RecordSource.

Hi thank you for the idea, I already solved the problem. I include the company name in the datasheet and hide it.