Search box criteria help

[matey56]

Hi,


I have three search boxes on my form using the code [CODE]Me.Filter = "

 like '*" & FIND & "*'" & " AND [Location] like '*" & FIND2 & "*'" & " AND [Status] like '*" & FIND3 & "*'"

Works perfectly, but all the locations start with a country code (e.g. IN Mumbai) If a user searches for "IN" locations it returns anything with the string "in" in it (e.g. US Kinston). How can I write the script to only search/return capital letters?

[Welshgasman]

Remove the leading * for locations?

[matey56]

Remove the leading * for locations?

That doesn't work. Is there a way to only search the first two characters in a string? That may work

[Welshgasman]

That doesn't work. Is there a way to only search the first two characters in a string? That may work

It will work?
If you enter IN for location, then anything that starts with IN will get selected AS LONG as the other criteria does not exclude that data.

Perhaps you should be using OR ?

[matey56]

It will work?
If you enter IN for location, then anything that starts with IN will get selected AS LONG as the other criteria does not exclude that data.

Perhaps you should be using OR ?

Help me out here. I'm not following. Where do I make these changes?

Me.Filter = "[Code] like '*" & FIND & "*'" & " AND [Location] like '*" & FIND2 & "*'" & " AND [Status] like '*" & FIND3 & "*'"

[Micron]

How can I write the script to only search/return capital letters?

StringComp() ?

[Welshgasman]

Me.Filter = "[Code] like '*" & FIND & "*'" & " AND [Location] like '*" & FIND2 & "*'" & " AND [Status] like '*" & FIND3 & "*'"

Start learning to debug your code. Test just the location control until you get it correct. In fact test each individually.

Me.Filter = "Code like '*" & Me.FIND & "*'  AND Location like '" & Me.FIND2 & "*' AND Status like '*" & Me.FIND3 & "*'"
Debug.Print Me.Filter

Also get used to debugging the strings you build with Debug.Print to see if you have what you *think* you have.

[matey56]

Start learning to debug your code. Test just the location control until you get it correct. In fact test each individually.

Me.Filter = "Code like '*" & Me.FIND & "*'  AND Location like '" & Me.FIND2 & "*' AND Status like '*" & Me.FIND3 & "*'"
Debug.Print Me.Filter

Also get used to debugging the strings you build with Debug.Print to see if you have what you *think* you have.

That's why I'm here, because I don't know how to do that! I'm piecing this all together as I go with zero training.

[señor_sriracha]

INSTR(table.column, "IN", 0) > 0

[Welshgasman]

That's why I'm here, because I don't know how to do that! I'm piecing this all together as I go with zero training.

Well see my links, that is what they are there for.
Did you try my amendments?

[matey56]

Well see my links, that is what they are there for.
Did you try my amendments?

Yes, I removed the asterisk correctly this time and I think it's working the way the user needs it to. I have mud on my face.

Thank you VERY much!