Auto fill field on form

's Computer Specifications

Using 2007 -- Have a form with customer ID and customer name. Would like to
enter the customer ID and have it automatically fill in the customer name.

's Computer Specifications

"Deanna" <(E-Mail Removed)> wrote in message
news:61C42352-D05E-4AF6-BE43-(E-Mail Removed)...
> Using 2007 -- Have a form with customer ID and customer name. Would like
> to
> enter the customer ID and have it automatically fill in the customer name.

That's easy, but remember, you should not store the customer name twice, NOT
FOR ANY REASON.

Use a combo box with 2 columns, store the customer ID and display the
Customer name.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Auto fill field when form opens w/ value from previous form	Pamela	Microsoft Access Forms	1	22nd Jul 2008 06:09 PM
Query to auto fill field on form	=?Utf-8?B?Y2FycmlldG9t?=	Microsoft Access Form Coding	0	31st May 2007 01:46 AM
Auto Fill-in Field on Second Form	=?Utf-8?B?UEhpc2F3?=	Microsoft Access Forms	4	19th Jul 2006 04:52 PM
Auto fill a form field	=?Utf-8?B?UGFtZWxh?=	Microsoft Word Document Management	1	8th Apr 2005 07:42 PM
Re: Auto Fill Form Field	Hugh O'Neill	Microsoft Access Forms	0	3rd Sep 2003 03:52 PM