Automatically update field in table

[Obeide115654]

Hi
I have two fields [First Name] and [Surname] which I would like to
automatically be updated into a third field [Mentor].
I need to store these names in both formats as I have this dbase linked to
others which use the information in different ways.
Can anybody help me?

 

[Allen Browne]

See:
Calculated fields
at:
http://allenbrowne.com/casu-14.html

The article explains how to use the AfterUpdate event procedure of the
dependent controls to update the target one.

However, I don't believe this is a valid scenario for doing this. You might
be much better of to create a *query* for others to use. In the query you
type this expression into the Field row:
Mentor: Trim([FirstName] + " " & [Surname])
Now you have the Mentor field for them to use instead of storing it in the
table, and it can't possibly go wrong.

 

[Obeide115654]

Thank you so much, I haven't really cracked queries yet! That has solved my
problem.
Thanks again.

See:
Calculated fields
at:
http://allenbrowne.com/casu-14.html

The article explains how to use the AfterUpdate event procedure of the
dependent controls to update the target one.

However, I don't believe this is a valid scenario for doing this. You might
be much better of to create a *query* for others to use. In the query you
type this expression into the Field row:
Mentor: Trim([FirstName] + " " & [Surname])
Now you have the Mentor field for them to use instead of storing it in the
table, and it can't possibly go wrong.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Hi
I have two fields [First Name] and [Surname] which I would like to
automatically be updated into a third field [Mentor].
I need to store these names in both formats as I have this dbase linked to
others which use the information in different ways.
Can anybody help me?