Is that the exact syntax you use? Doesn't look right.
I'd expect the prompts to be in square brackets?
I'm guessing you get the syntax right otherwise I guess it would never work.
I'm not clear what you mean by works for a while, loops, and enter it again.
You mean you have to set up the whole query again or you have to enter the name again? Any query prompt you enter a value for isn't designed to be stored forever, just until the next time you run the query in my experience.
I have found that sometimes if you put a filter on in access you think you've filtered it, or you don't click off the filter before saving and it gets lost, but something built into a query should not be being lost if you are saying you have to re-add the "like" to the query?
Let me know and I'll help as much as I can.