Please help me word this Like statement.

[Ngabay]

I am trying to use a Like statement with an input box. The Like statement is not working properly, it is acting as an =.

![name] Like [Enter name: ]

How do I get the above statemnt to work properly?

If I enter "Ty" then all the names with "TY" should display.

Thank you,
NG

 

[Savil]

![name] Like '"*[Enter name: ]*"'

 

[Ngabay]

Thank you for your reply Savil,


I made the recommended changes but the input box is not poping up. I donnot believe that the quotes work with an input box. Any other suggestions?

Thanks,
NG

 

[Savil]

That works

![name] Like '"*' & [Enter name: ] & '*"'

tried it myself