I have more than one thread going relating to this question in hopes of
getting to the answer.  I hope that is ok with everyone...

Let me be specific as to exactly what I am hoping to accomplish with this
project. I have about 300 employees that work Day shift, Swing Shift, and
Graveyard shift. Many of them have names that are hard to remember or
pronounce.

I would like to be able to type part of a name into a box and return a match
for everyone out of the group that matches. My associated table contains
information about what shift the employee works, his days off, which
supervisor he reports to, what section he works in etc.

I have worked out (with some help from MVP John Vinson) a query that I feel
is ideal for accomplishing this. The criteria is:

Like ‘*’& [Enter Part of Employee Name ] &‘*’

I can also repeat this on the OR line and Access will search both First
Names and Last Names and return a few lines with employees that match with
the wild card criteria. All the user needs is to remember part of the name,
just enough to narrow down the results.

For this, a combo box will not work. I need a text box and I think that if I
base the form on the query I will get the results from the query that I want
if I can just input the wildcard criteria. I would not expect a user of this
to work under the query tab so it needs to be a form where criteria is input
and results are viewed.

I am so close but so far away because I know how to make the query, I think
I know how to make the form based upon the query. I know how to place
controls but I can’t make the [censored] control accept an input to make it
all happen!