[AccessD] Auto Lookup

Hi Gowey

Sound like a job for a combobox ...

/gustav

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