Exact Match in Search

[ddrew]

How can I get an exact match in a search. If I search for say C1 I get results showing everything with C1 i.e C1, C11, C12, C13 etc. I just want to show C1's
This shows my query at present.

Like [Forms]![Search]![BoxNo] & "*"

 

[Meltdown]

should be...

Like [Forms]![Search]![BoxNo]

 

[ddrew]

Yup! thats what I thought but it still calls everything with C1 in it!

 

[boblarson]

If you use the word LIKE at all, it will not give you anything BUT what you are getting.

You need to eliminate the use of LIKE when you want to use a specific search term.

So, you can use some conditional programming to determine which it is you want to use.

 

[godofhell]

Use enter [Forms]![Search]![BoxNo] without the like, this will make the stament be treated as =[Forms]![Search]![BoxNo] so it will only bring up C1