How to syntax Like *FormControlValue* correctly in criteria? 1

[inso18]

I've tried Like "*"&[Forms]![myForm]![myControl]&"*" with no success.
Please help.

 

[HarleyQuinn]

You'll need quotes e.g.:

Like "[red]'[/red]*"&[Forms]![myForm]![myControl]&"*[red]'[/red]"

Hope this helps

HarleyQuinn
---------------------------------
Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[inso18]

Nope, this doesn't work either.

 

[HarleyQuinn]

What isn't working? Syntax error? Unexpected results?

HarleyQuinn
---------------------------------
Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[inso18]

the code you gave me is a query criteria and instead of selecting the correct records, it doesn't select any records at all, ie, it doesn't work correctly.

 

[HarleyQuinn]

Use the .Text property then:

Like "*" & [Forms]![Form1]![Text7].[Text] & "*"

HarleyQuinn
---------------------------------
Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[inso18]

It does work in this way. Thanks!!

 

[HarleyQuinn]

Glad I could help

HarleyQuinn
---------------------------------
Get the most out of Tek-Tips, read FAQ222-2244 before posting.