Help with user inputs

[CP]

I am a novice database writer and need to know which is the best way of
dealing with an input problem.

I have a field that I wish users to enter a customer name or enter a new
one, I need them to enter data and see if any part of the name may appear
(take into accout they are not access orientated)

example - customer is W M GOOGLE

the can enter w / wm / google, then anything in that field will show up with
any of that criterea or nothing leaving it blank to enter.

What I need to know briefly is the best solution:-
i think, query then form with a list box but not sure on setting that up?

 

[KARL DEWEY]

Use a combo with AutoExpand property set to Yes.
But your field should last name only as some may enter 'willian mark google'
and never find it. The same goes if the enter 'bill google'. But with
last name entering 'goolge' they wil see the rest an be able to select the
correct one.