From: Deanna on
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.
From: Arvin Meyer [MVP] on
"Deanna" <Deanna(a)discussions.microsoft.com> wrote in message
news:61C42352-D05E-4AF6-BE43-F255D7A15E1C(a)microsoft.com...
> 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