QUERY BY LAST NAME

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table that consist of over 150 records of employee information. How
can I creat some sort of way that when I type in their last name that only
those records are retrieved for updating? I just want the record I need to
update displayed in a form format that I use to enter new employees. Please
help your assistance will be greatly appreciated.

Thanks in advance,

Joe Richardson
 
Do this in a form.

The simplest approach might be to add an unbound combo that takes you to the
record when you type the person's name into the list. There is a combo
wizard to do this, or you can copy the code from this article:
Using a Combo Box to Find Records
at:
http://allenbrowne.com/ser-03.html
 
Back
Top