how to put in a look up

  • Thread starter Thread starter Foster1
  • Start date Start date
F

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
 
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.
 
Back
Top