Default value (1 Viewer)

[EricH]

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 its different.

When I set the DefaultValue Property for CTL2 to an expression "=[CTL1]" Access actually is looking at the DefaultValue Property setting for CTL1 NOT the VALUE of CTL1.

How do I get round this??

Eric

 

[KevinM]

When you populate CTL1, then automatically populate CTL2 at the same time..

How ins CTL1 being poplulated?

 

[EricH]

CTL1 is populated from a query which combines fields from a Customers table (CustID, CustName, CustCountry, etc) and another table (call it MainTable).

There is a lookup control from which I can select CustName then CustCountry is automatically added. However, I need a separate field for the Ship-To Country, so I want to offer the CustCountry in the Ship-To Country as a default but change it if different.

Does that help?

Eric