[AccessD] Auto Lookup

Hi All,


I am trying to complete a project on a Mail Processing database.  The
one part I am stuck on now is some way for the Auto lookup of a record
everytime a number is put it.

I have a form in which it has 5 fields, the first field is the ID of the
person receiving the mail, the next four fields depend on this number to
be filled in.

What I need it to be able to do is as the user puts in a number it will
auto check the table for the ID number and fill the fields on the form
with the underlying info with out the user having to press enter or Tab
to have update or search, something like on each Key Down or Key Up.
For example say the ID to enter is 123456, when the user enters the 1 it
will do a auto check for a ID of 1 and when the user enters 2 it will do
a auto check for a ID of 12 and so forth.

I hope that makes sense.  Thanks for any info or examples anyone has to
accomplish this, if it is at all possible.


Thanks,

Mike Gowey, MCSA, A+
Team Leader - SRCI
Information Systems & Services Division