Auto Fill Text Boxes While user Types

I have a combo box will all the fields a user can choose, if a user chooses Name Field, then in the text box named txtSearch the user then starts typing, lets say they type "A", then using the field they selected it would then look through the database then auto complete or fill in the reset of the word with the next item that had "A" and another letters.

So while they are typing "A" then "ndy" would appear then if they typed "Ad" then "am" would appear.

How can look at a table using Access and in VBA complish such a feat?

Not sure if this should be in the Office Forum or the Database Forum

If your using Access and can use a combo box instead then there is a property to autocomplete the typing for you.