Query constraint that is "Like" the current value of a text box 1

[osera]

This one has several of us stumped.

If I write my query constraint as *Test*, it will find any record where "Test" appears in the field in question.

If I write my constraint as [Forms]![Form1]![Combo0], it will find any record where the field is the same value as whatever is in Combo0.

My question, how do I combine the two of them? Is it possible to write a constraint that will find anything that is Like the current value of a combo or text box? For example, I want to search a list of projects for all that have been assigned to a particular person, whether that person is the only one assigned or part of a group. But I want to pick the name from a list instead of having to re-code the query for each name.

If there is an answer that will only work using SQL or VBA code, I'll take it.

 

[lespaul]

I think it's:

LIKE "*" & [Forms]![Form1]![Combo0] & "*"

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for database developers:
The Fundamentals of Relational Database Design
Understanding SQL Joins

 

[osera]

Leslie,

Many thanks! I'm not sure how we managed to miss that since we tried just about every combination of using the '&' to concatenate the text sections.

I can now return to my disguise of the office miracle worker.