View Single Post
  #2  
Old May 17th, 2010, 05:43 AM posted to microsoft.public.access.forms
Arvin Meyer [MVP][_2_]
external usenet poster
 
Posts: 2,310
Default Auto fill field on form

"Deanna" wrote in message
...
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