[AccessD] Auto Lookup

Yeah it is, I got that already.  It's the rest of the puzzle that I need
to work out.

-----Original Message-----
From: Gustav Brock [mailto:gustav at cactus.dk] 
Sent: Tuesday, November 25, 2003 8:26 AM
To: Access Developers discussion and problem solving
Subject: Re: [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.

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com