Automatically Complete Names

[Bonestein]

I have a Name field in a form that I have to enter the same name multiple times.

How can I make the name field, look at the table and pick the closest matching name and put it in the field that I am typing in?

what I am wanting is like excell works as you are typing down the columns, it will recognize the name and fill in the rest for you and you just press tab to finish it if it was the right name you wanted.

 

[PHV]

You may consider a ComboBox with AutoExpand set to True.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Bonestein]

sorry, I haven't really used access much or any at all. Can you give a little more information?

where or how to find or make the ComboBox?
then would the AutoExpand be in the Design view somewhere?

 

[Bonestein]

Ok, I have found what you were talking about.

Thanks for your help