I want to use a field as the default value for another field

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

Guest

I am setting up a table that includes the field "First Name" and "Familiar
First Name" I want the default for the second field to be the first since in
most cases, it's the same-I cannot find out how to do this anywhere!! There
must be an expression or something???
 
Kathy said:
I am setting up a table that includes the field "First Name" and
"Familiar First Name" I want the default for the second field to be
the first since in most cases, it's the same-I cannot find out how to
do this anywhere!! There must be an expression or something???
Click to expand...

Nope, because all default values are assigned the instant the "New record"
position is displayed, before you have had an opportunity to enter a value
in [First Name].

On a Form (where all data entry belongs) you can use the AfterUpdate event
of [First Name] to set the value of [Familiar First Name]

If IsNull(Me![Familiar First Name]) = True Then Me![Familiar First Name] =
Me![First Name]
 
Back
Top