Default Value

[BarryC]

how do I make the default value the value from another field. I tried the
default value option in the properties but it does not work.

 

[Rick Brandt]

how do I make the default value the value from another field. I tried
the default value option in the properties but it does not work.

You can't. The default value is populated before the "other" field is
filled in so it would always be null.

You can use VBA code in a form to get the same functionality. In the the
AfterUpdate of the first field...

Me.OtherFieldName = Me.FieldName

 

[BarryC]

Thanks, works good

You can't. The default value is populated before the "other" field is
filled in so it would always be null.

You can use VBA code in a form to get the same functionality. In the the
AfterUpdate of the first field...

Me.OtherFieldName = Me.FieldName