[AccessD] Auto Lookup

Well, as you've figured that a combobox is the best tool for the job, all
you need to do now is educate the user's of the world of possibilities that
would open up if only they'd learn to press the enter key after selecting an
item in the combobox. Problem solved. <g>

Lambert

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