Default Value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
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
 
Back
Top