OK so ive got my search form working. But I need to refine my querry, at present it reads
Like "*" & [Forms]![Search]![Box No] & "*"
So if I put in E1 it will return E1, E11, E12, E13 i.e anything with E and 1 in it.
Can it be refined to only give what I ask i.e if I ask for E1 then all I get is E1. I'm sure this is really simple, but!
Like "*" & [Forms]![Search]![Box No] & "*"
So if I put in E1 it will return E1, E11, E12, E13 i.e anything with E and 1 in it.
Can it be refined to only give what I ask i.e if I ask for E1 then all I get is E1. I'm sure this is really simple, but!
