[AccessD] Auto Lookup

Mike

...this is pretty standard stuff ...both of these sites have sample code and
dbs that demonstrate different methods of getting the form populated with a
record selected from a combo box ...HTH :)

http://www.mvps.org/access/
http://www.candace-tripp.com/access_downloads.htm

William Hindman
Government is not reason, government is not persuasion,
government is force. It is a dangerous servant." G. Washington

----- Original Message ----- 
From: "Gowey Mike W" <Mike.W.Gowey at doc.state.or.us>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Tuesday, November 25, 2003 9:50 AM
Subject: [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
>
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>