Default value

[Allan Martin]

Can a field in an Access 2000 db have a default value
equal to another field that is automatically generated?
Can I use expression builder to accomplish this ...or?

 

[Graham Mandeno]

Hi Allan

No, you can't set this to happen automatically, but you have a couple of
options:

1) In the BeforeUpdate event of your form, you can check to see if the field
is null, and poke the value into it:
If IsNull(Me.Field2) then Me.Field2 = Me.Field1

2) You can use a calculated query expression to use the value from another
field if the field in question is null. For example:
ShipTo: IIf( IsNull( [PhysicalAddress] ), [PostalAddress],
[PhysicalAddress] )