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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kathy D - 26 Apr 2005 16:13 GMT

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???

Reply to this Message

Rick Brandt - 26 Apr 2005 16:25 GMT

> 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???

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]

Signature

I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Reply to this Message