textbox manipulation

[cracocasse]

Hello,

I am new in Access and I need some help regarding a search form.

I have arround 6000 clients name.

and I would like to make a my life easier to search for a name

I would like to :

1) have a textbox1 where I write the name
2) have another textbox2 where the list of names appear while typing.
3) it should be simultaneous search ( like facebook) where every letter i type in textbox1 will narrow the research in textbox2.
4) I also have a querry named myquery1 where I put the criteria like form.formname.textbox1 & * ( if this can help).

Maybe someone can help me in the build code ??

thank you again for your help

 

[John Big Booty]

Perhaps this sample will help you get started.

 

[cracocasse]

Thank you very much .....your sample was indeed a great help

 

[John Big Booty]

Glad to be of assistance