Default Value

B

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.
 
R

Rick Brandt

BarryC said:
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
 
B

BarryC

Thanks, works good

Rick Brandt said:
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
 
Top