G Guest Mar 28, 2005 #1 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.
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 Mar 28, 2005 #2 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. Click to expand... 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 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. Click to expand... 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
G Guest Mar 28, 2005 #3 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 Click to expand...
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 Click to expand...
