Auto fill field on form
in [Form]
|
Prev: Selecting Photos from and ComboBox list then print on a Report
Next: Field name derived from a string value returns a Run-time error 2465.
From: Deanna on 16 May 2010 22:31 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 17 May 2010 00:43
"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 |