Example VB Script to show records like *AAA*

[Glowackattack]

Hi,
i have a button that i want to open a form and only show records that have *AAA* in a certain field, and i cant get the wildcard characters to work...can someone post an example so i can see the syntax??

Thanks for the help.

 

[pbaldy]

What have you tried? You want "Like" rather than "=".

 

[Glowackattack]

I'm looking for the VB syntax, I've tried a number of things

stLinkCriteria = "[Case Name]=" & "*"

stLinkCriteria = "[Case Name]=" & "'*'"

to start just to try to find the syntax.

Can i use "Like" in that Visual Basic statement??

 

[pbaldy]

Not only can you, but you must.

stLinkCriteria = "[Case Name] Like '*AAA*'"

 

[Glowackattack]

Beautiful, thanks very much, thats exactly what i was looking for.