I am trying to get a control to take its Default Value from the VALUE of another control on the same form (lets say CTL2 looks at CTL1).
CTL1 (Country) is automatically filled in from a Customers table via a query, and the CTL2 (Ship-To Country) is normally the same country, but occasionally...