Adding text to table using a formula

[Annnnn]

Hi,



I'm not sure if what I want is possible but here I go.

I have a very simple table and have a form that I can use to add information to this table, and that all works fine, but subsequently I want to create a "sample_name" within this form and add
it to my table.
To create the Sample_name I use a formula =Replace([Patient_name],"-","") but when I save it it does not store the information in the main table. (so, everything is added to the table but the sample_name)

In the main table I have a column that is called sample_name but I cannot seem to link it to the field in the form.

I Hope it's a bit clear what i main

Tnx

Cheers

[ranman256]

Replace is not really a formula but rather an 'action' event.
It wants to physically alter the data, not display data.

so either:
run the replace action to fix the data, (update query)
or
to display data, youd want something like:

left([field],instr([field],"-")-1) & mid([field],instr([field],"-")+1)

but this ONLY works if every record has the dash.

[Annnnn]

Hi tnx,
But I really want to "create" data from data found in 2 other fields. So it's not that I want to only display the data because the data does not yet exists.

I have the following fields that I want to manually enter:
Sample_Type : Tissue
Patient_Name : 00-000-000

From these 2 I want to make 00000000T (or in case the Type is: Reference; ending on R)

It is really a form for data entry

[Annnnn]

Never mind I got it XD XD

[June7]

Why save calculated value? It can be calculated when needed.

Name parts should be saved into individual fields.

Why does the name value have a hyphen and why do you need to remove it? In some names a hyphen is a valid character.

[Annnnn]

Why save calculated value? It can be calculated when needed.

Name parts should be saved into individual fields.

Why does the name value have a hyphen and why do you need to remove it? In some names a hyphen is a valid character.

I know it is a valid character, but we make a difference between patient namens (with "-" ) and sample names which also indicates what kind
of material it is. So the 2nd name is based upon the first name.
May seem strange to u but that's how it has to work because everything I do has to be anonymous...

It has to be saved because this is a actual value for that perticular sample type received upon a specific date from a specific patient.