Find text string from query 1

[IANGRAND]

I have a form where the user types in part of their address. I have the query looking up this textbox, but want it to find the addresses that contain the specific text string.

What is the ocde i require to enter in the expression builder. I have tried "like", but to no avail.

Cheers

Ian

 

[HarleyQuinn]

Can you show us how you tried using LIKE?

HarleyQuinn
---------------------------------
Help us to help you,
read FAQ222-2244 before posting.

 

[IANGRAND]

It's not right,

Like [Forms]![Form1]![Text7]

probably not using it correctly.

Ian

 

[HarleyQuinn]

You need to use a wildcard character. Something like:

Like [Forms]![Form1]![Text7] & *

Hope this helps

HarleyQuinn
---------------------------------
Help us to help you,
read FAQ222-2244 before posting.

 

[HarleyQuinn]

Sorry, that should have read

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

Cheers

HarleyQuinn
---------------------------------
Help us to help you,
read FAQ222-2244 before posting.

 

[HarleyQuinn]

Or even:

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

I'll post it right eventually

HarleyQuinn
---------------------------------
Help us to help you,
read FAQ222-2244 before posting.

 

[IANGRAND]

Great stuff, works a treat.

Cheers

Ian