Automatically update field in table

O

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

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.
 
O

Obeide115654

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


Allen Browne said:
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.

Obeide115654 said:
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?
 
Top