how to put in a look up

[Foster1]

I would like a look up or whatever in my data base. I have many unusual
names in the data base and it is hard to come up with the correct spelling of
a name. I would like to just be able to enter the first letter of the last
name and have all names starting with that letter come up along with the ID
number I have assigned. I do not have much programing knowledge so it should
be easy to do.

I am using Office Professional 2007.

Thank you
Foster1

 

[Allen Browne]

Have you noticed the Search box in the horizontal scrollbar of datasheets in
Access 2007? Will this do what you need?

Or perhaps you would like to try this approach:
Find as you type - Filter forms with each keystroke
at:
http://allenbrowne.com/AppFindAsUType.html

The article has a downloadable example, and is largely copy'n'paste into
your own database.